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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Gable, Josh
Sent: October 8, 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