You may download/install operational reporting program and use it to guide 
about the good SQL statements.


-----Original Message-----
From:   Gable, Josh [mailto:josh.gable AT EDS DOT COM] 
Sent:   Thursday, October 09, 2003 9:20 PM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        Re: SQL script for total traffic

I'll check it out and see what I can come up with.  Thanks for all the
responses.

Josh

-----Original Message-----
From: Talafous, John G. [mailto:Talafous AT TIMKEN DOT COM]
Sent: Wednesday, October 08, 2003 2:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL script for total traffic


select sum(bytes)/1000/1000 as "MB_per_day" from summary where
activity='BACKUP' and (current_timestamp-end_time)hours <= 24 hours

However, this only looks at backup traffic. You may want to look at archive
traffic as well.

John G. Talafous              IS Technical Principal
The Timken Company            Global Software Support
P.O. Box 6927                 Data Management
1835 Dueber Ave. S.W.         Phone: (330)-471-3390
Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
talafous AT timken DOT com           http://www.timken.com


-----Original Message-----
From: Gable, Josh [mailto:josh.gable AT EDS DOT COM]
Sent: Wednesday, October 08, 2003 9:27 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL script for total traffic


Hello TSMers,

Does anyone have a good SQL query to determine the total amount of data
you've backed up in the last 24 hours?  It would need to capture all data
received, since we have backups that go to disk and tape concurrently.

Thanks in advance for any assistance,

Josh Gable
EDS
Enterprise Storage - Tulsa Backup and Recovery
MD 326
4000 North Mingo Road
Tulsa, OK 74116-5020