All VOlumes (Offsite + Onsite + etc)
select count(*) from volumes

All DB VOlumes
select count(*) from dbvolumes

-----Original Message-----
From: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK]
Sent: Thursday, February 06, 2003 3:43 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: total volumes usage in TSM.


q vol only gives storage pool volumes not dbb volumes





Muthyam Reddy <mreddy AT joy DOT com> on 02/05/2003 10:16:25 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  total volumes usage in TSM.



** High Priority **

Please this is emergency.

Hi ,
Here I'm trying to count total volumes usage in tivoli by adding
q vol+scratch tapes in library wich I got 450 tapes and these are defined in
primary,copy storage pools.
But in volume history shows 800 unique tapes used in different dates.

Deffenetly I missed something in my formula.....

Please can anybody explain correct formula to count total number of volumes
using by tsm (onsite+offsite).

my assumption is 'q vol' gives volume list of primary,copy pools and using for
dbb.

We are using drm.

thanks in advance

/mani


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

This electronic mail transmission contains information from Joy Mining Machinery
which is confidential, and is intended only for the use of the proper addressee.
If you are not the intended recipient, please notify us immediately at the
return
address on this transmission, or by telephone at (724) 779-4500, and delete this
message and any attachments from your system.  Unauthorized use, copying,
disclosing, distributing, or taking any action in reliance on the contents of
this
transmission is strictly prohibited and may be unlawful.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++








**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************