Filespace data won't tell him anything.
 
If you have TSM accounting turned on, look for the dsmaccnt.log file. That 
contains a wealth of historical backup/restore information, broken down by date 
and TSM client.
 
--
Mark Stapleton (mark.s AT evolvingsol DOT com)
Senior consultant

________________________________

From: ADSM: Dist Stor Manager on behalf of Stef Coene
Sent: Fri 3/23/2007 9:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Shrinking scratch pools - tips?



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