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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
David E Ehresman
Sent: April 29, 2004 11:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select Commands
grep your accounting log for the nodes you are interested in.
>>> Ray.Louvier AT HALLIBURTON DOT COM 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
|