Hello everyone!

Quick question to all of you SQL experts.  I want to find all offsite tapes
associated with a certain node. I already have the following select
statement.  I was wondering if it is possible to get a listing of all of
the tapes and at the bottom of this have a total?  Also, is it possible to
have a wildcard for the storage pool name?  Some of the nodes may be on
multiple offsite tape pools and I was just wondering if there would be an
easier way of doing this? For example, all of my offsite tape pools begin
with tapecopy... is masking possible or do I just need to run multiple
selects.

select volume_name,node_name from volumeusage where node_name='XXXXXXX' and
stgpool_name='XXXXXXX' order by volume_name,node_name

If I put the word distinct in front of volume_name, will that just list
each tape once?

Thank you all so much in advance!!!!

Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338