q vol * acc=unavailable


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Avy Wong
Sent: Tuesday, January 30, 2007 11:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: volumes with unavailable status only


Hello,

      How do you  go about getting a list of volumes that shows with
access=unavailable only. I tried many versions of select statement but not
getting it right. Thanks.


tsm: TSM>q vol DR5057 f=d

                   Volume Name: DR5057
             Storage Pool Name: 3584TAPEPOOL
             Device Class Name: 3584
            Estimated Capacity: 200,000.0
       Scaled Capacity Applied:
                      Pct Util: 3.7
                 Volume Status: Filling
                        Access: Unavailable
        Pct. Reclaimable Space: 3.4
               Scratch Volume?: Yes
               In Error State?: No
      Number of Writable Sides: 1
       Number of Times Mounted: 23
             Write Pass Number: 1
     Approx. Date Last Written: 10/10/2006 11:38:28
        Approx. Date Last Read: 01/12/2007 16:43:49
           Date Became Pending:
        Number of Write Errors: 0
         Number of Read Errors: 0
               Volume Location:
Volume is MVS Lanfree Capable : No
Last Update by (administrator): WONGAV
         Last Update Date/Time: 01/12/2007 16:46:26
          Begin Reclaim Period:
            End Reclaim Period:




Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
ext 28164


****************************************************************************
**********************
The information contained in this message may be privileged and confidential
and
protected from disclosure. If the reader of this message is not the intended
recipient, or
an employee or agent responsible for delivering this message to the intended
recipient,
you are hereby notified that any dissemination, distribution, or copy of
this
communication is strictly prohibited. If you have received this
communication in error,
please notify us immediately by replying to the message and deleting it from
your
computer.
****************************************************************************
**********************

Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.
Please be advised that someone other than the intended recipients, including
a third-party in the Seligman organization and government agencies, may
review all electronic communications to and from this address.