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 [EMAIL PROTECTED] http://www.timken.com -----Original Message----- From: Gable, Josh [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 9:27 AM To: [EMAIL PROTECTED] 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