Another way would be to do an export node for each filespace, preview=yes,
one export for filedata=backup, another export for filedata=backupactive.
It has the added benefit of telling you the number of files, in case you're
interested in that.  I found it useful for tracking down why one of my
node's occupancy was six times the size of the filespace.  (Turned out they
were backing up an overnight temp directory that had a high churn rate.)

Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail

-----Original Message-----
From: Richard Sims [mailto:rbs AT BU DOT EDU]
Sent: Saturday, November 01, 2003 3:12 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Query to see all active / inactive file statistics?


>I4ve looked extensively through the list archive, but couldn4t find any
>matching post.
>I am looking for a query/statement/script that gives an overview of all
>active / inactive files for any particular node, and the storagespace
>accompanied with that. I4d like to be able to determine what the impact
will
>be when I4ll lower the backup copy group settings for a specific domain.

That reminds me...I could be golfing.
You could do a Select on the BACKUPS table to generate a report on the
file complement involved.  No server-side lookup operation will give you
actual file sizes, however.

I would take a more statistical approach:  Use Query Occupancy and Query
Auditoccupancy to get overall file numbers and space used.  From Query
Filespace you get space numbers for the Active files (or you could just
go to the client and examine its file system for space used plus number of
file system objects (e.g., inodes).  You can do subtraction and averaging
to get a quick sense of the overall population.

  Richard Sims, BU