I've run in to a similar req to justify tapes.  (Kinda like justifying we need 
electricity) Anyway what I did is in excel using the odbc ran the sql below on 
each server which tells me the amount of backup data the backup server is 
maintaining.  Then the following day I run a audit license on each TSM server 
which updates the occupancy of each node, copy that data to a new line in 
excel, then re-run the query below which populates the data of the previous 
days backup then I figure the difference.

I've been doing this on a weekly basis for two years and now show one heck of a 
trending line.

Or you could just use the TSM Operational reporter product witch tells you 
daily how much was backed up.


SQL Statement to get All Backup Client Occupancy

SELECT AUDITOCC.NODE_NAME, AUDITOCC.BACKUP_MB, AUDITOCC.BACKUP_COPY_MB, 
AUDITOCC.ARCHIVE_MB, AUDITOCC.ARCHIVE_COPY_MB, AUDITOCC.SPACEMG_MB, 
AUDITOCC.SPACEMG_COPY_MB, AUDITOCC.TOTAL_MB
FROM AUDITOCC AUDITOCC

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Owings, Don
Sent: Tuesday, August 31, 2004 3:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select for Tape Use


Why you ask?  Because I'm having to justify ordering tapes and in order to do 
that I have to organize the data in order create some type of forecasting.  
What I'm looking for is a down and dirty select statement that just shows the 
previous nights usage.  Maybe it's in TSM but I haven't found it, plus I'm 
dealing with TB's of data so I need it consolidated.

Hope that clarifies what I'm trying to do.


Don

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
David E Ehresman
Sent: Tuesday, August 31, 2004 2:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select for Tape Use


> I'm looking for a select statement that shows exactly what tapes were
used the previous night
>and what was written to the tapes.

Why?  TSM keeps track of all that so you don't have to.