SELECT VOLUME_NAME FROM VOLUMES WHERE ACCESS='UNAVAILABLE' everything except UNAVAILABLE can be lower case.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Hart, Charles Sent: Thursday, April 15, 2004 8:41 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Stephan Dinelle Sent: Thursday, April 15, 2004 7:38 AM To: [EMAIL PROTECTED] 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?
