If you only have to do a specific few machines, and not on a regular basis,
you can do an "export node NODENAME FILEData=active PREVIEW=yes"

The result of this will tell you how much active data the node has.  I've
also tried a Select statement, multiplying the capacity by pct_utilized in
the filespaces table, but never felt the results were very accurate.

Nick Cassimatis


----- Forwarded by Nicholas Cassimatis/Raleigh/IBM on 09/05/2007 06:02 PM
-----

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/05/2007
02:50:17 PM:

> Hello.  I have a need to provide a report that details how much data
> each client has if I were to perform one full backup or restore of
> the server.  I am pulling my hair out trying to figure out the right
> select statement to query the information.  Has anyone done this
> before and can you please provide me the select statement, or other
> method, of finding this data?
>
> Thanks.
>
> +----------------------------------------------------------------------
> |This was sent by scottcorp AT fuse DOT net via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT com.
> +----------------------------------------------------------------------