The parallel backup feature (set by resourceutilization) means that ONE
backup session makes SEVERAL accounting log entries / summary table entries.
This is indeed confusing.

Don't you wish there were a product that would take care of this? ;-}

--Lindsay Morris, at servergraph.com
> -----Original Message-----
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Jeff Connor
> Sent: Friday, June 29, 2001 4:35 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: total # of bytes by each client on a daily basis
>
>
> 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 <wboyer AT PTD DOT NET>@VM.MARIST.EDU> on 06/29/2001 04:10:56 PM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> 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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Cook, Dwight E
> Sent: Friday, June 29, 2001 11:33 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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:Tony.Jules AT OLYMPUS DOT COM]
> Sent: Friday, June 29, 2001 9:53 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
> tony.jules AT olympus DOT com
>