Don't remember which version of the 3.7 code brought in this table. Just
remember seeing it after one of my upgrades, looked at it and fell in love!!
:-) My servers are right now at 3.7.3.0 on both AIX and OS/390.
Bill
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Sheets, Jerald
Sent: Friday, June 29, 2001 5:15 PM
To: [EMAIL PROTECTED]
Subject: Re: total # of bytes by each client on a daily basis
I'm a little confused here...
I was actually looking to figure out how to do this when you folks started
talking about it. So, I pulled out my trusty data-extraction tools and
found out that I don't have a SUMMARY table.
Anybody wanna take a crack at that?
Jerald Sheets, Systems Analyst TIS
Our Lady of the Lake Regional Medical Center
5000 Hennessy Blvd, Baton Rouge, LA 70808
Ph.225.765.8734..Fax.225.765.8784
E-mail: [EMAIL PROTECTED]
-----Original Message-----
From: Jeff Connor [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:35 PM
To: [EMAIL PROTECTED]
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 <[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]
