Actually, if you understand how to use MS EXCEL, to pull the data out of the dsmaccnt.log... I am not too good at it but the log is formatted (comma delimited) for this type of manipulation.
George Lesho AFC Enterprises Kevin Sawyer <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/06/2001 02:18:45 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: total monthly backups I like to use the Query Occupancy command. q occ will tell you the logical and physical filespaces as well as sort by node. Logical is actual space used and physical is the container (filespace). It would be easy to redirect that output from the dsmadmc into a script that awks and sums the columns for you. Kevin. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Toni Banire Sent: December 6, 2001 2:41 PM To: [EMAIL PROTECTED] Subject: total monthly backups Need help on this one Is there a way to extract a list of total backups over a monthly period. I currently have this SQL statement SELECT start_time, end_time, entity, bytes from summary where activity ='BACKUP' and end_time between 'start_date' and 'end_date' To get a list of backups run, I just total all entity values. The snag here is that if a TSM client has it resourceutilisation set to >1 I will get duplicate listings for any day during the backup period as it will list objects processed on each client and not just the client. Does anyone know if there is a better way to do this to get a list of total monthly backups by client and not object. TIA Toni
