Hiten
Unregistered / Unconfirmed
Hi,
I am using Tivoli Storage Manager version 5.4.5 in which i customised the report to get start & end time for backup with size in GB. Now i want to modify the same & want to obtain the media details also by each pool in which backup happen. How can i obtain or modify the script below.
Select entity, substr(cast(min(start_time) as char(29)),1,10) as "start date" , substr(cast(min (start_time) as char(29)),12,8) as"start time", substr(cast(max(end_time) as char(29)),1,10) as "end date", substr(cast(max(end_time) as char(29)),12,8) as "end time", cast(bytes/1024/1024/1024 as decimal(6,2)) as GB, successful from summary where activity='BACKUP' and start_time>= (current_timestamp - 24 hours) group by entity, successful, bytes
Kindly help.
I am using Tivoli Storage Manager version 5.4.5 in which i customised the report to get start & end time for backup with size in GB. Now i want to modify the same & want to obtain the media details also by each pool in which backup happen. How can i obtain or modify the script below.
Select entity, substr(cast(min(start_time) as char(29)),1,10) as "start date" , substr(cast(min (start_time) as char(29)),12,8) as"start time", substr(cast(max(end_time) as char(29)),1,10) as "end date", substr(cast(max(end_time) as char(29)),12,8) as "end time", cast(bytes/1024/1024/1024 as decimal(6,2)) as GB, successful from summary where activity='BACKUP' and start_time>= (current_timestamp - 24 hours) group by entity, successful, bytes
Kindly help.