Try:

Select volume_name,date(last_read_date) from volumes

        Al

Alan Davenport
Senior Storage Administrator
Selective Insurance
alan.davenport AT selective DOT com
(973)948-1306


+ -----Original Message-----
+ From: Matthew Large [mailto:matthew.large AT PHOENIXSM DOT COM]
+ Sent: Thursday, September 27, 2001 10:31 AM
+ To: ADSM-L AT VM.MARIST DOT EDU
+ Subject: Select Statement
+
+
+ I need to find out which volumes from a particular storage
+ pool were used
+ least recently.
+
+ so far I have
+
+ tsm> select last_read_date from volumes
+
+     LAST_READ_DATE
+ ------------------
+
+
+
+
+         2001-09-05
+    16:26:59.000000
+         2001-09-12
+    09:35:36.000000
+         2001-08-24
+    11:28:11.000000
+
+
+
+ Clearly my select statement skills are highly inadequate and
+ this output
+ isn't enough, I need the volume names aswell. I assume display by
+ chronological order is default.
+ Can anyone offer some assistance?
+
+ Many Thanks All.
+
+
+ http://www.phoenixitgroup.com
+ ******************Internet Email Confidentiality
+ Footer*******************
+
+ Phoenix IT Group Limited is registered in England and Wales
+ under company
+ number 3476115.  Registered Office: Technology House,
+ Hunsbury Hill Avenue,
+ Northampton, NN4 8QS
+
+ Opinions, conclusions and other information in this message
+ that do not
+ relate to the official business of our firm shall be
+ understood as neither
+ given nor endorsed by it.
+
+ No contracts may be concluded on behalf of our firm by means of email
+ communications.
+
+ Confidentiality: Confidential information may be contained in
+ this message.
+ If you are not the recipient indicated (or responsible for
+ delivery of the
+ message to such person), you may not take any action based on
+ it, nor should
+ you copy or show this to anyone; please reply to this email
+ and highlight
+ the error to the sender, then delete the message from your system.
+
+ Monitoring of Messages: Please note that we reserve the right
+ to monitor and
+ intercept emails sent and received on our network.
+ Warning:  Internet email is not 100% secure. We ask you to
+ understand and
+ observe this lack of security when emailing us. We do not accept
+ responsibility for changes made to this message after it was sent
+
+ Viruses: Although we have taken steps to ensure that this
+ email and any
+ attachments are free from any virus, we advise that in
+ keeping with good
+ computing practice the recipient should ensure they are
+ actually virus free.
+