Drop the "not" and it will work fine.  You might want to order by node_name.

Bob

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Larry Clark
Sent: Wednesday, January 07, 2009 5:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Request for some TSM queries to use

How About this? Would it provide a list of volumes used by each node is a
storage pool?:

      select distinct volume_name,node_name,stgpool_name from volumeusage
where not stgpool_name='<my_store_pool_name>'

This electronic transmission and any documents accompanying this electronic 
transmission contain confidential information belonging to the sender.  This 
information may be legally privileged.  The information is intended only for 
the use of the individual or entity named above.  If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or the taking of any action in reliance on or regarding the contents of this 
electronically transmitted information is strictly prohibited.