William,
Can you post the Select statements, reports on this site ?
Rajesh Oak
--
On Fri, 29 Jun 2001 16:10:56
William Boyer wrote:
>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]
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/