Hallo,
I used the Windows Integrated Solutios Console (ISC) to control the
Windows-Backup Server.
It works (not everything) nice :-X .
Now I have a Problem with the Server-Scirpting. I think I make a small
error but I don`t find him.
I have following Skript:
######
query event * * begindate=-1 begintime=08:00 enddate=today endtime=08:00
QUERY EVENT * TYPE=ADMIN BEGINDATE=today-1 BEGINTIME=08:00 ENDDATE=today
ENDTIME=08:00 EXCEPTIONSONLY=NO FORMAT=STANDARD
q request
select cast(entity as char(25)) as "Node Name ", cast(bytes/1024/1024
as decimal(10,3)) as "Total MB ",cast(substr(cast(end_time-start_time
as char(17)),3,8) as char(8)) as "Elapsed ",
cast(substr(cast(start_time as char(26)),1,19)as char(30)) as
"Date/Time ", case when cast((end_time-start_time) seconds as
decimal) >0 then cast(bytes/cast((end_time-start_time) seconds as
decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as
" MB/Sec" from summary where start_time>=current_timestamp - 1 day and
activity='BACKUP'
q stgpool * Format=Standard Pooltype=Any
q libvolume
q volume * stgpool=* devclass=* format=standard
q path
#####
This Script works every day very nice. But with the ISC I can not change
something because
my row select cast(en......... has an error (Macro-Definition).
I can change the script with the Command-Line Mode in the
Tivoli-Storage-Management Console.
with the command update, copy .... but not with the ISC.
Who can wright me, where the mistake is?
Thank you and best regards
Christiane
--
************************************************
Institut für Informatik
Christiane Kühn Tel.: 0228/73-4200
Römerstraße 164 Fax.: 0228/7360304
53117 Bonn Email: kuehn AT uni-bonn DOT de
************************************************
|