> From: thaddad AT COLUMBIAENERGYGROUP DOT COM
> Subject: Re: How to predict which tapes will be mounted during restor
>
> Hope this helps...SQL select in V3 .... will list all tapes volumes that hol
> data of a specific client/node..
> (did notice that node name must be in uppercase)
>
>
> Select  volume_name from volumeusage where nodename='xxxxxxxxxxxxxx'

The adsm command:

                           show volumeusage node

displays the volumes also.