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:[EMAIL PROTECTED] Sent: 21 July 2003 19:36 To: [EMAIL PROTECTED] Subject: Re: Stats Thanks, Good one, Bill Rosette Data Center/IS/Papa Johns International WWJD Richard Sims <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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.
