Hi, Gary.  To expand it to handle a set of nodes, you can use something
like:

... where node_name in ('NODE1','NODE2','NODE3')

Or you can use a sub-select:

... where node_name in (select node_name from [some_table] where yatta)

Alex


________________________________
Alex Paschal
Storage Solutions Engineer
MSI Systems Integrators
(503) 943-6919 - Office
________________________________

Your Business.  Better.




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary D.
Sent: Wednesday, April 01, 2009 5:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Sql question

I would like to set up a qurey for volumes in a storage pool which do
not contain data from a set of clients.

Or, if easier, a list of volumes in a pool which contain data from any
of a set of clients.

I have a script for doing this with a single client, but not sure about
expanding it to handle a set.

Any help would be appreciated.

Tsm server v5.4.4 running on suse sles9.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310



This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.