If it is, you can't make your accounting out of this table........ Gerhard Wolkerstorfer [EMAIL PROTECTED] (William Boyer) am 05.07.2001 20:32:29 Bitte antworten an [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT) Thema: Re: Antwort: Re: total # of bytes by each client on a daily basis I'm assuming it's the amount of data transferred. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gerhard Wolkerstorfer Sent: Thursday, July 05, 2001 5:35 AM To: [EMAIL PROTECTED] Subject: Antwort: Re: total # of bytes by each client on a daily basis Bill, when you fell in love with this table: Do you know, what the value in the Field BYTES means ? When the activity is BACKUP, is the value in the field BYTES the amount of BYTES TRANSFERRED or BYTES BACKUPED ? I remarked, when a Node is backing up and some big files change during the Backup (and TSM is retrying the files!) , the Number of Bytes transferred is much higher than the Number of Bytes Backuped. And if you account the number of Bytes transferred, your customer wouldn't be happy ! Gerhard Wolkerstorfer [EMAIL PROTECTED] (William Boyer) am 02.07.2001 06:00:39 Bitte antworten an [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT) Thema: Re: total # of bytes by each client on a daily basis 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]
