select volumes.volume_name,volumes.last_write_date FROM
STGPOOLS,LIBVOLUMES,VOLUMES WHERE STGPOOLS.STGPOOL_NAME='XXXXXXXXX' 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: 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 old and I need to see how
old.
Thanks in advance
Matt