Re: sql query required
2006-07-17 09:34:31
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.
|
|
|