Mark,

In these cases is when you have to use the ADSM SQL facility, issue the
following command:

select count(distinct NODE_NAME) as "# of Clients", VOLUME_NAME from
VOLUMEUSAGE where \
STGPOOL_NAME='YOURSTGPOOL' group by VOLUME_NAME


Saludos/Regards

IBM de México
José Eduardo Martínez Cordero.
System Management Controls.
Automation Management.
Tel. (5) 270 4506   T/L 879 4506
email: emartine AT mx1.ibm DOT com


Mark Mooney <Mark.Mooney AT SWPC.SIEMENS DOT COM>@VM.MARIST.EDU> on 28/12/99
02:46:50 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:  Q CON



Is there a way to tell which client's data is on a tape besides doing a q
con
for that tape?  We are using colocation and some tape have more than just
one
client's data on them because we ran out of scratch tapes at one point so
instead of doing a Q CON for those tapes to see if they need to be
re-migrated
to sort the data out i was wondering if there was a way to see how many
clients
have data on that tape.  I know that SHOW VOLUSE will tell me which tapes a
clients data is on but i want to know the reverse.

Thanks
Mooney
Siemens-Westinghouse