I use the following select statement to list all tapes for the pimary 
storagepools
last written from yesterday 19:00 to today 10:00.

select volume_name as Volume, stgpool_name as Stgpool, date(last_write_date) as 
"Date", - 
time(last_write_date) as "Time" from volumes where - 
last_write_date > timestamp(date(current_date-1 day),'19:00:00') and -
last_write_date < timestamp(date(current_date),'10:00:00') and -
stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY')


-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Joni Moyer
Gesendet: Mittwoch, 22. März 2006 16:39
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] Find what tape a particular backup resides on


Hello,

I have tried this command:  select * from volumeusage where
node_name='NAS_SERVER_2_OFFSITE' and have received the following output:

    NODE_NAME: NAS_SERVER_2_OFFSITE
     COPY_TYPE: BACKUP
FILESPACE_NAME: /
  STGPOOL_NAME: TAPE_NDMP_OFFSITE
   VOLUME_NAME: N00020
  FILESPACE_ID: 47

I guess my next question would be, how do I find a listing of particular
tapes that were just created over the weekend?  Saturday (3/18/2006) and
Sunday (3/19/2006)

I believe that I would probably also combine this command with either the
volumes or volhistory table, but I cannot seem to find a way to
successfully combine them.  Any help is appreciated!  Thanks!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************



             "Choudarapu,
             Ramakrishna
             (GTI)"                                                     To
             <Ramakrishna_Chou         ADSM-L AT VM.MARIST DOT EDU
             darapu AT ML DOT COM>                                             
cc
             Sent by: "ADSM:
             Dist Stor                                             Subject
             Manager"                  Re: Find what tape a particular
             <[email protected]         backup resides on
             .EDU>


             03/22/2006 10:14
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name'

Regards,
Rama





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Wednesday, March 22, 2006 10:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Find what tape a particular backup resides on


Hello everyone,

I am trying to figure out what tape a particular backup is on for our
NAS
NDMP full backups.  I noticed that you can query the node_name, FSID,
filespace_name, etc.  but is there a way that I can tie the volume table
onto this so that I can see which tape(s) have server_1's backups on?
This
is on a TSM 5.2.4.5 server on AIX.  Thanks in advance!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute it. Click here for important additional terms relating to
this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------