SELECT VOLUME_NAME FROM VOLUMES WHERE ACCESS='UNAVAILABLE'

everything except UNAVAILABLE can be lower case.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Hart, Charles
Sent: Thursday, April 15, 2004 8:41 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Adding a report section in TSM Operational Reporting


I actually use TSM query Statements on my Op Reporting tool... seems to work
fine.  have you tried it yet?  (I'm using the Beta7 drv)

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Stephan Dinelle
Sent: Thursday, April 15, 2004 7:38 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Adding a report section in TSM Operational Reporting


I would like to add that command to the TSM Operational Reporting tool:


q vol acc=unavail


But, since that tool accepts only SQL statement, I have difficulties
converting the TSM command in SQL format!


Can somebody help you?