Sunday, June 19, 2011

how much data in GB has been backed up in a certain timeframe?

Select:

sum(cast(bytes/1024/1024/1024 as decimal(6,2))) Backed_up_in_GB

from summary where start_time>=current_timestamp - 24 hours and activity="BACKUP"

No comments:

Post a Comment