Maybe the easiest is to either from the original server or from another Windows box with the TSM client, start the client CLI and run a QUERY BACKUP for *.PST files with -SUBDIR=YES. If you want all, the include the -INA flag to get the inactive version(s), too. It's quick and easy. Pipe the output to a file and you might be able to import it in to Excel.
Sure beats trying to query the BACKUPS table! :-) Bill Boyer "I haven't lost my mind...it's backed up on tape somewhere!" - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thach, Kevin G Sent: Friday, October 19, 2007 8:20 AM To: [email protected] Subject: Select statement for space occupied by type of file? Hello- I'm trying to determine the amount of space occupied by .pst files for a certain node. I cannot figure out a good way to gather this information. The backups table doesn't have size information, and the occupancy table doesn't have file information. Can anyone offer up a select statement that would work? Thanks so much! ----------------------------------------- This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended only for the use of the Individual(s) named above. If you are not the intended recipient of this E-mail, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this E-mail is strictly prohibited. If you have received this E-mail in error, please immediately notify us at (865)374-4900 or notify us by E-mail at [EMAIL PROTECTED]
