Command to find empty slots in library

[pinsky]

I am trying to find a command to tell me how many slots are free in our tape library. Is there such a command??

 

[chad_small]

TSM doesn't track every element in the library, just those with tapes (private/scratch) in them. You can find that information by getting a count of total slots from the library control panel or manufacuterer specs and then do a count on the number of tapes in the library and subtract one from the other. That works, but has its drawbacks if tapes were checked out but not removed or put into the library directly and a checkin did not grab them.



SELECT (3000-(COUNT(VOLUME_NAME))) AS FREE_SLOTS FROM LIBVOLUMES



Again this is not 100% accurate but will work. The 3000 value is to be replaced by the total number of tapes your library can hold.