Look at the TSM accounting records in dsmaccnt.log You must have accounting turned on; but all you have to do is enter: set accounting on TSM creates the dsmaccnt.log file in the server install directory. dsmaccnt.log is a comma-delimited file, easy to import into EXCEL. The fields are described in the TSM Server admin guide (look in the index under ACCOUNTING).
An accounting record is created for each SESSION that does backups or archives. You cannot see the size of individual FILES that are archived, but you can get the total of the archived files for a particular month, by client. Wanda Prather "I/O, I/O, It's all about I/O" -(me) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sujay Dinakar R. Sent: Monday, July 17, 2006 7:33 AM To: ADSM-L@VM.MARIST.EDU Subject: sql query required Dear all, can any one please tell me how to find the size of the archived files in a particular month. by issuing the command select * from Archives where ARCHIVE_DATE > '2006-01-01 08:00:00' AND ARCHIVE_DATE < '2006-02-01 18:00:00' i could able to get the list of files and file ID but i could not able to get the size coloum. can any one know how to get the size of the archived files. Best Regards sujay dinakar r Regards Sujay Dinakar .R --------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
