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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Sujay Dinakar R.
Sent: Monday, July 17, 2006 7:33 AM
To: ADSM-L AT VM.MARIST DOT 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.