You may want to set up a script as follows -  the parameter ($1) is the
node name of interest.

select * from backupsets, volhistory where node_name = upper('$1') and
backupsets.date_time = volhistory.date_time

or, if you only want only the volumes on which a given node has backupsets,
use the following script:

select node_name, backupset_name, volume_name from backupsets, volhistory
where node_name = upper('$1') and  backupsets.date_time =
volhistory.date_time

I have also had 'orphan' backupset cartridges left in a tape library, esp
when the deletion in 3.7 "almost" worked. Use to following select to find
these:

select * from volhistory where type ='BACKUPSET' and volhistory.date_time
not in (select date_time from backupsets)

Joerg Pohlmann


"Mills, John" <John_Mills AT PURINAMILLS DOT COM>@VM.MARIST.EDU> on 2001-10-04
05:30:02

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: BACKUPSET's


That did the trick.  Thanks Herve!