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
