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