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

Re: list of last write date on all tapes

2001-07-09 Thread Dixon, Swonda
2838 Sent: Monday, July 09, 2001 11:32 AM To: [EMAIL PROTECTED] Subject: list of last write date on all tapes Does anyone know an easy way to list off all the last write dates of all tapes? Or of at least selected pools? I know I have tapes that have not gone back to scratch status. Many of them are

list of last write date on all tapes

2001-07-09 Thread MC Matt Cooper (2838)
Does anyone know an easy way to list off all the last write dates of all tapes? Or of at least selected pools? I know I have tapes that have not gone back to scratch status. Many of them are old and I need to see how old. Thanks in advance Matt