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  

Reply via email to