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

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -