Thanks very much guys! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Boyer Sent: Friday, October 19, 2007 9:13 AM To: [email protected] Subject: Re: Select statement for space occupied by type of file?
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]
