Re: list of last write date on all tapes

2001-07-09 Thread Robin Sharpe
select volume_name,date(last_write_date) as last_written from volumes Robin Sharpe Berlex Laboratories

Re: list of last write date on all tapes

2001-07-09 Thread Prather, Wanda
aselect volume_name, last_write_date from volumes where stgpool_name in ('BACKUPSTK1','BACKUPSTK2') order by last_write_date -Original Message- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 11:32 AM To: [EMAIL PROTECTED] Subject: list of last write dat

Re: list of last write date on all tapes

2001-07-09 Thread Dixon, Swonda
select volumes.volume_name,volumes.last_write_date FROM STGPOOLS,LIBVOLUMES,VOLUMES WHERE STGPOOLS.STGPOOL_NAME='X' and volumes.stgpool_name=stgpools.stgpool_name -Original Message- From: ADSM Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of MC Matt Cooper 2838 Sent: Monda