Thanks to IBM who supplied me with this answer when I asked the same
question.

select * from volumeusage where node_name='XXX'

James Louie
Nabisco

> On Friday, July 31, 1998 5:04 PM, Karen Krowzack
> [mailto:Karen.M.Krowzack AT UCM DOT COM] wrote:
>
> Have you any of you written an SQL statement in V3 ADSM that
> tells you every
> tape that a node has data written on?  I know it CAN be done
> (probably), and
> IBM software support told me they get many request for this.
> But before I
> try to re-invent the wheel, I thought one of your smart ADSMers might
> already have done this - without doing a 'query content' two
> hundred times
> and trying to search the outputtted results for the node in question.