Hello, I have created this script to create a request listing of tapes to be returned from our vault when they are empty. As you can see from the select statement that I run daily it will have duplicates within it since I have a delay of 5 days. Is there a certain way I can manipulate this script so that on the 1st day that a tape becomes pending it is placed within this listing? Or is there an easier way to create this list? Thanks in advance for your help!
select volume_name from volumes where stgpool_name='TAPE_NDMP_OFFSITE' and devclass_name='NASDEV' and status='PENDING' or status='EMPTY' and volume_name like 'N%' order by volume_name ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************