This should also show you the amount of active data on a node in MB:

select sum(capacity*pct_util/100) from filespaces where node_name='XXXXXXXX'



-----Original Message-----
From: William Rosette [mailto:Bill_Rosette AT PAPAJOHNS DOT COM]
Sent: 21 July 2003 19:36
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Stats


Thanks,
Good one,
Bill Rosette
Data Center/IS/Papa Johns International
WWJD



                      Richard Sims
                      <rbs AT BU DOT EDU>             To:
ADSM-L AT VM.MARIST DOT EDU
                      Sent by: "ADSM:          cc:
                      Dist Stor                Subject:  Re: Stats
                      Manager"
                      <[email protected]
                      .EDU>


                      07/21/2003 01:39
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






>I am looking for a way to figure a total Gb of active files on a
particular
>node. ...

Hello, Bill - This question came up a few weeks ago, and the excellent
              suggestion was the expedient:

Active files, number and bytes          Do 'EXPort Node NodeName
                                            FILESpace=FileSpaceName
                                            FILEData=BACKUPActive
                                            Preview=Yes'
                                        Message ANR0986I will report the
                                        number
                                        of files and bytes.

(This is immortalized in http://people.bu.edu/rbs/ADSM.QuickFacts)

   Richard Sims, BU

Any e-mail message from the European Central Bank (ECB) is sent in good faith 
but shall neither be binding nor construed as constituting a commitment by the 
ECB except where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any 
unauthorised disclosure, use or dissemination, either in whole or in part, is 
prohibited.
If you have received this e-mail in error, please notify the sender immediately 
via e-mail and delete this e-mail from your system.