Select volume_name from volumes where volume_name not in (select volume_name from libvolumes)
Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 6:46 AM To: [EMAIL PROTECTED] Subject: missing volumes Hello, I would like to know how to compare volume names in volumes and libvolumes with a select statement. Or if there are other ways to determine missing volumes? I use 4.1.3.0. ex. I dont use DRM but I send my volumes offsite and update their access to offsite. I bring back my volumes onsite, I do a checkin and an 'upd vol * access=readw wherestg=copypool whereaccess=offsite wherestatus=empty'. If the volumes arent checked in the library or by some reason still are offsite when they are updated I will miss/need them sooner or later... How do I find eventually missing volumes? Dont suggest using DRM, I will if there is a need for that product (server to server). tia \\Henrik ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.