Query for total backup space count

[TaSMania]

Other than running

select date(start_time) as start_time,sum(bytes/1024/1024/1024) as GB_BYTES from summary where activity='BACKUP'group by date(start_time)

to get average of daily backup data, is there any other way like Query * something that's not in the admin reference?

 

[marclant]

For an average, do use "avg" instead of "sum"
avg(bytes/1024/1024/1024)

Or you could do the math:
(sum(bytes/1024/1024/1024)/count(bytes))

 

[marclant]

The Operations Center - Overview Page also gives you info about the also 24 hours and the previous 24:


The General Operations Report also gives you additional info:

 

[TaSMania]

so from OC which data should I compare to the data from my select statement?
Data I got from select statement does not match any data in OC.