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 [email protected] Certified Deployment Professional Tivoli Storage Manager 6.1 +---------------------------------------------------------------------- |This was sent by [email protected] via Backup Central. |Forward SPAM to [email protected]. +----------------------------------------------------------------------
