|
Re: How much space does a file (active version) use?
2005-03-01 09:56:57
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
|
|
|
