> and multiply pct_utilized by capacity.

And you can let TSM do that math if you want:

select filespace_name,
       pct_util,
       capacity,
       pct_util * capacity / 100 as "TOTAL MB"
   from filespaces
   where node_name='STORMAN'

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-01
07:56:33:

> 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