You may download/install operational reporting program and use it to guide about the good SQL statements.
-----Original Message----- From: Gable, Josh [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 9:20 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:39 PM To: [EMAIL PROTECTED] 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 [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
