[ADSM-L] Getting backup duration in TSM 6.2 select statement

Hi there guys,

After much searching and figuring out how to do select statements on TSM 6.2
This is what I have come up with for backups.

You can manipulate it to suit you.

SELECT substr(char(start_time),1,19) AS 
START_TIME,timestampdiff(4,char(timestamp(end_time) - (start_time))) AS 
ELAPTIME_IN_Minutes,cast(activity as varchar(16)) as Activity,cast(number as 
varchar(16)) as Process_Number,cast(entity as varchar(30)) as 
Entity,cast(float(bytes) /1024/1024/1024 AS DEC(10,2)) AS GB,cast(successful as 
varchar(16)) as Successful FROM summary WHERE activity='BACKUP' AND 
end_time>current_timestamp-48 HOURS

Hope this helps you.

Let me know if you need anything else.

Kind Regards
Rennad Murugan
rennad AT gmail DOT com
Certified Deployment Professional
Tivoli Storage Manager 6.1

+----------------------------------------------------------------------
|This was sent by rennad AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------