Re: SQL script for total traffic
2003-10-08 15:41:10
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
|
|
|