Will this work for you?

tsm: TSMSRV1>select volume_name,cast(last_write_date as date) as
Date,cast(LAST_WRITE_DATE as time)as TIME from volumes where
devclass_name='3590TAPE' and
cast((current_timestamp-LAST_WRITE_DATE)days as decimal)=1 and
status='FULL'


VOLUME_NAME                  DATE         TIME
------------------     ----------     --------
000034                 2004-08-30     11:46:38
000079                 2004-08-30     13:00:20
000093                 2004-08-29     22:55:01
000098                 2004-08-30     05:57:27
000147                 2004-08-30     16:16:14
000165                 2004-08-30     00:58:03
001182                 2004-08-30     02:53:58
001392                 2004-08-29     20:42:10
001409                 2004-08-30     09:14:30
A00317                 2004-08-30     09:22:33
A00843                 2004-08-30     14:55:18

tsm: TSMSRV1>select count(*) as Total_Tapes_Used from volumes where
devclass_name='3590TAPE' and
cast((current_timestamp-LAST_WRITE_DATE)days as decimal)=1 and
status='FULL'

TOTAL_TAPES_USED
----------------
              11 

This is selecting the full tapes that were last written to between 24
and 48 hours ago.


H. Milton Johnson
Voice: (210) 677-6728
 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Hart, Charles
Sent: Tuesday, August 31, 2004 3:38 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select for Tape Use

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.