Thanks very much guys! 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
William Boyer
Sent: Friday, October 19, 2007 9:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Thach, Kevin G
Sent: Friday, October 19, 2007 8:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
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 hdesk AT covhlth DOT com