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" <[email protected]> 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 [EMAIL PROTECTED] via Backup Central. > |Forward SPAM to [EMAIL PROTECTED] > +----------------------------------------------------------------------
