On Apr 30, 2008, at 3:39 PM, David Hensley wrote:
My scripts are not working correctly. Can someone inform me of the command that will let me know what volumes were used in the previous nightly incremental back up? I need to be able to find these tapes and manually check them out of the library.
If collocating by node or filespace, the following sample Select will probably do what you want... Put in an actual storage pool name in place of the NOT LIKE clause to reduce overhead, if there is a particular one. Select VOLUME_NAME, STGPOOL_NAME, - LAST_WRITE_DATE from VOLUMES - where VOLUME_NAME in - (select distinct VOLUME_NAME from - VOLUMEUSAGE where NODE_NAME='ACSN03' - and STGPOOL_NAME not like '%COPY%' - and STGPOOL_NAME not like '%OFFSITE%') - order by LAST_WRITE_DATE Richard Sims
