Duration of last night's backups

[redplumptomato]

Hi all,

I'm wondering if someone out there can assist.

I'd like to run a query which shows me to total duration of all backups that ran last night.

something that would show:

Total Schedules: Total Backup Size Total Backup Duration


I'm using EMC's DPA and surprised that it doesn't have this feature (or, i just can't find it.)

So, doing this via script would be nice.

 

[rowl]

You might want to check out http://www.lascon.co.uk/tsm-sql-queries.php for some good examples. I have found that site very helpful for getting info out of TSM.

-Rowl

 

[BrianV]

Use this to get total backup size:

SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPEMOUNT' AND activity<>'EXPIRATION' AND end_time>current_timestamp-24 hours GROUP BY activity

 

[redplumptomato]

Excellent!!