You could also code a SELECT command to run against the SUMMARY table. I
have created several reports in Crystal Reports from this table. For client
sessions, seems to have the same information as the accounting records, but
this table also includes server processes. I produce reports for client
activity and server processes for a day from this table.
Bill Boyer
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Cook, Dwight E
Sent: Friday, June 29, 2001 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: total # of bytes by each client on a daily basis
What exactly are you looking for out of your query ?
You might be better off turning accounting on and just look at accounting
records, there will be one for each session a client initiates.
It is real easy to pull accounting records onto a PC and load them into
Excel (or some similar spread sheet)
Dwight
-----Original Message-----
From: Tony Jules [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 9:53 AM
To: [EMAIL PROTECTED]
Subject: total # of bytes by each client on a daily basis
I am backing up about 100 nodes on a daily basis. Every morning, I run the
following command for each node at the server command line:
q act begind=today-1 search=nodename
How can I create a script to perform the same operation on all the nodes at
once and present it in a spreadsheet-like format?
Thank you
Tony Jules
ITS / Olympus America Inc.
631-844-5887
[EMAIL PROTECTED]