Yes, all tapes are in this query.  To further define list add in the "where" 
clause the stgpool_name you want or don't want.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5525
david.longo AT health-first DOT org


>>> shekhar.dhotre.b AT BAYER DOT COM 03/01/01 12:38PM >>>

tsm: TSM>select volume_name,node_name from volumeusage where node_name='MEDRS1'g
         roup by volume_name,node_name

VOLUME_NAME            NODE_NAME
------------------     ------------------
MED200                 MEDRS1
MED200                 MEDRS1
MED201                 MEDRS1
MED251                 MEDRS1
MED254                 MEDRS1
MED255                 MEDRS1
MED260                 MEDRS1
MED261                 MEDRS1
MED501                 MEDRS1
MED506                 MEDRS1
MED507                 MEDRS1
MED511                 MEDRS1
MED513                 MEDRS1

:-)  :-)    thanks ...  Is it showing me offsite (Copypool) tapes in this query 
?




Maria Paz Gimeno <mpgimeno AT IBERCOM DOT ES>@VM.MARIST.EDU> on 02/28/2001 
12:14:39 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU 
cc:

Subject:  Re: How to find out what tape's a client data are on ?


The most probable mistake is that the node name should be in capital
letters.
You have to write exactly what TSM has in its database.
Do a query nodes to find out
Regards
Maria