Re: [ADSM-L] available slots left
2007-04-12 14:56:03
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.
**************************************************************************************************
|
|
|