>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
