ADSM-L

Re: [ADSM-L] available slots left

2007-04-12 14:56:03
Subject: Re: [ADSM-L] available slots left
From: William Boyer <bjdboyer AT COMCAST DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 12 Apr 2007 14:05:57 -0400
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Avy Wong
Sent: Thursday, April 12, 2007 1:26 PM
To: ADSM-L AT VM.MARIST DOT EDU
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.
**************************************************************************************************