nathrix
ADSM.ORG Member
Hi Guys and Girls,
The statement I have has the following header information displayed:
NODE
TOTAL_MB
SCHEDULE_START
SCHEDULE_END
LENGTH_MIN
Is it possible to add the following to above statement (TSM V6):
NODE
ACTIVITY ( was it a BACKUP or ARCHIVE)
SCHEDULE (client event/schedule name)
SCHEDULE_START
SCHEDULE_END
STATUS (the result completed, missed, failed)
LENGTH_MIN
Thanks in advance!
The statement I have has the following header information displayed:
NODE
TOTAL_MB
SCHEDULE_START
SCHEDULE_END
LENGTH_MIN
select cast(entity as char(25)) as NODE,cast(sum(bytes/1024/1024) as decimal (10,3)) as Total_MB, -
substr(cast(min(start_time) as char(26)),1,19) as SCHEDULE_START,substr(cast(max(end_time) as char(26)),1,19) as SCHEDULE_END, -
(timestampdiff(4,char(max(end_time)-min(start_time))))as Length_min from summary where start_time>=current_timestamp -24 hours -
and activity='BACKUP' group by entity
Is it possible to add the following to above statement (TSM V6):
NODE
ACTIVITY ( was it a BACKUP or ARCHIVE)
SCHEDULE (client event/schedule name)
SCHEDULE_START
SCHEDULE_END
STATUS (the result completed, missed, failed)
LENGTH_MIN
Thanks in advance!