>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