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