On Friday 23 March 2007, Bell, Charles (Chip) wrote:
> Since this a GREAT place for info, etc., I though I would ask for
> tips/how-to's on tracking down why my scratch pools are dwindling, for
> LTO/LTO2/VTL. My guess is I have a couple of clients that are sending out a
> vast amount of data to primary/copy. But without a good reporting tool, how
> can I tell? Expiration/reclamation runs fine, and I am going to run a check
> against my Iron Mountain inventory to see if there is anything there that
> should be here. What else would you guys/gals look at?  :-)  Thanks in
> advance!
If you want to sort filespaces by date:

select * from filespaces order by BACKUP_START


Stef