Bill,
I've just started to experiment with Crystal and the summary table as well.
Do you use the Resourceutilization Client option at all? If so, how do you
combine the
summary table entries for all the sessions generated during a given clients
nightly
incremental backup to produce the type of report Tony is looking for?
Can you send me a copy of your select statement?
Thanks,
Jeff Connor
Niagara Mohawk Power Corp
Syracuse, NY
William Boyer <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/29/2001 04:10:56 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: total # of bytes by each client on a daily basis
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]
