Using one of the undocumented SHOW commands: SHOW SLOTS <libraryname>
Will list out how many usable slots there are in the library. Then SELECT COUNT(*) FROM LIBVOLUMES Will tell you how many you're using. Simple math from there. You can also make a server script Def scr q_slots 'SELECT <#slots>-count(*) as "Total Slots Available" FROM LIBVOLUMES' And then RUN Q_SLOTS any time you want to know. Add a WHERE LIBRARY_NAME='<library name>' if you have more than 1 library defined. Just remember that the volumes in LIBVOLUMES are those that are checked in. If you have volumes physically in the library, but not checked in to TSM, your count will be off. Bill Boyer "Backup my harddrive? How do I put it in reverse?" - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Thursday, April 12, 2007 1:26 PM To: [EMAIL PROTECTED] Subject: available slots left Hello, How do I go about finding out how many slots left available in my library?Thanks. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860) 862-8164 cell (860) 961-6976 ************************************************************************************************** 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. **************************************************************************************************
