Does anyone know of an SQL query that can show all the tapes which belong to
a certain node.

I tried select node_name,volume_name from volumeusage where node_name='xxxx'

But I'm wondering whether this is giving me a history of all the tapes this
node has ever used rather than what it is using today.

Nathan

Nathan King
MCSE, IBM ADSM CS
Open Systems Storage Management
*  (210) 913-5755
* Pager: 753-5755
* E-mail: nathan.king AT usaa DOT com

The opinions herein are mine and almost certainly do not reflect those of my
employer.