sql - TSM command to get the count of backup in GB's? -
can 1 please provide me tsm command count of backup in gb's last 30 days?
an example of sql command can execute on tsm data size last 24 hours:
select substr(entity,1,20) "node", cast(sum(bytes/1024/1024) decimal(8,2)) "mb bkp" summary activity = 'backup' , start_time>=current_timestamp - 24 hours group entity order 2 desc
i haven't worked on tsm many years, can not change number of hours in clause 24 hours * 30 days?
select substr(entity,1,20) "node", cast(sum(bytes/1024/1024) decimal(8,2)) "mb bkp" summary activity = 'backup' , start_time>=current_timestamp - 720 hours group entity order 2 desc
to gb, divide bytes again 1024 in select clause.
Comments
Post a Comment