dsmc q backup -nodename=node '{\\node\d$}\directory\*.pst' -subdir=yes 
>c:\path\output.txt

Load the output into excel as fixed width text.

-----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 5: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