Mark, Thanks for the help. I tried the commands and the results appear to be what I was looking for, I just want to make sure that the results are for active files only and not active/in-active files?
JR "Stapleton, Mark" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 03/01/2005 08:56 AM Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] How much space does a file (active version) use? From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of JR Trimark >Does anyone know how to write a sql script that would display >how much data (active version only) would be restored for a >volume/drive? No, but there's a much easier way: query filesp <nodename> <filespacename> and multiply pct_utilized by capacity. The SQL equivalent is: select filespace_name,pct_utilized,capacity from filespaces where node_name=<NODENAME> -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627