Call me a Unix junkie, but I prefer this little Unix Command from a prompt


# dsmadmc -id=admin -pass=******* 'q libv' | grep Scratch | awk '{print
$3,$2}' | cat -n

Output looks like this.

     1  Scratch 021814
     2  Scratch 021817
     3  Scratch 021837
     4  Scratch 021852
     5  Scratch 021871
     6  Scratch 021912
     7  Scratch 021922
     8  Scratch 021926
     9  Scratch 021938
    10  Scratch 021943
    11  Scratch 021954
    12  Scratch 021962
    13  Scratch 021974
    14  Scratch 021977
    15  Scratch 021980
    16  Scratch 021984
    17  Scratch 021987
    18  Scratch 021988
    19  Scratch 030232
    20  Scratch 030240
    21  Scratch 030268
    22  Scratch 030269
    23  Scratch 030270
    24  Scratch 030275
    25  Scratch 030293
    26  Scratch 030299
    27  Scratch 030301

Make that an alias and you're golden.  :-)


-
Tom Walker

-----Original Message-----
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: Query Scratch Volumes


 What would the syntax be for a query to only show scratch volumes?

This e-mail including any attachments is confidential and may be legally privileged. 
If you have received it in error please advise the sender immediately by return email 
and then delete it from your system. The unauthorized use, distribution, copying or 
alteration of this email is strictly forbidden.

This email is from a unit or subsidiary of EMI Recorded Music, North America

Reply via email to