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:[EMAIL PROTECTED] Sent: Saturday, November 01, 2003 3:12 PM To: [EMAIL PROTECTED] 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
