Re: SQL script for total traffic
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 CompanyGlobal 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
Re: SQL script for total traffic
Try this: SELECT ENTITY AS NODE_NAME, ACTIVITY, BYTES AS BYTES_TRANSFERRED, - START_TIME, END_TIME, IDLE AS IDLE_IN_SEC, MEDIAW AS MEDDIA_WAIT_IN_SEC, - PROCESSES, AFFECTED AS FILES_BACKUP, FAILED, EXAMINED AS ALL - FROM SUMMARY - WHERE START_TIME>TIMESTAMP(CURRENT DATE -1 DAY, '12:00:00') AND BYTES>0 /hector -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gable, Josh Sent: October 8, 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
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 CompanyGlobal 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
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 CompanyGlobal 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
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
