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" <mark.stapleton AT BERBEE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/01/2005 08:56 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: [ADSM-L] How much space does a file (active version) use?






From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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 (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627