Try this *** summary of the transferred bytes per day per node SELECT ENTITY AS "Node/Event", ACTIVITY as "Activity", - BYTES AS "Bytes Transferred", START_TIME AS "Start Time", - END_TIME AS "End Time", IDLE AS "Idle(Seconds)", - MEDIAW AS "Media Wait(Seconds)", PROCESSES AS "Processes", - AFFECTED AS "Files Backup", FAILED AS "Failed", - EXAMINED AS "Inspected" - FROM SUMMARY - WHERE START_TIME>TIMESTAMP(CURRENT DATE -1 DAY, '12:00:00') - AND BYTES>0
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of David E Ehresman Sent: April 29, 2004 11:20 AM To: [EMAIL PROTECTED] Subject: Re: Select Commands grep your accounting log for the nodes you are interested in. >>> [EMAIL PROTECTED] 4/28/2004 7:21:13 AM >>> Does anyone know a select command to pull out how much data was backed for an individual Node for that night. Yea I know you look at logs and find it but it would be much easier to setup a command to pull certain nodes to track just those. Ray
