Nathan,

It is my opinion that it gives you all tapes that the node is currently
using, though those tapes might be shared by other nodes.

Mark

> ----------
> From:         Nathan King[SMTP:nathan.king AT USAA DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Thursday, September 02, 1999 3:04PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      SQL Query
>
> 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.
>