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