SQL select statement for Backups and Archives last 24 Hours

nathrix

ADSM.ORG Member
Joined
Jun 5, 2007
Messages
37
Reaction score
0
Points
0
Location
South Africa
PREDATAR Control23

Hi Guys and Girls,

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!
 
Top