Hook up the ODBC driver on your windows system and use access or excel to
get the correct data from the tables. Not exactly intuitive at first
glance, but gets easier as you fool with it. See the archives for how to
set up the ODBC driver...
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (719) 260-5991
Email: [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Joshua S. Bassi
Sent: Tuesday, September 19, 2000 10:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Determining Capacity on ADSM?
How do I determine how many physical slots my 3494 library has?
mtlib -l /dev/lmcp0 -qL - off the top of my head. I don't' have
a 3494 in my lab environment here.
How do I determine how many tapes are offsite?
That depends if you are using DRM or not. If you are using DRM
then issue q drm. If not then maybe q volume access=offsite
How do I determine how many tapes total I have?
q volume - count 'em up. Or try
select count(*) from volumes - off the top of my head.
How do I determine the average capacity per tape?
q volume
--
Joshua S. Bassi
Senior Technical Consultant
Symatrix Technology, Inc.
[EMAIL PROTECTED]
