Hi,
Try the following command to report on all activity in the last 24 hours, in GB.
SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPE MOUNT' AND activity<>'EXPIRATION' AND start_time >{'2011-09-21 00:00:00'} AND start_time <{'2011-09-22 00:00:00'} GROUP BY activity
Another option is to use Operations Centre, which can be configured to email you you a daily report in HTML format showing the daily ingest and a lot of other useful information.
Regards
Darren
Darren Sanders
Principal Consultant
Celerity Ltd
http://www.celerity-uk.com