Yet another approach is to check if the non-collocated need collocation:

select node_name, sum(physical_mb) as "STORAGE"
 from occupancy where node_name in (select
 node_name from nodes where collocgroup_name is
 null and domain_name=upper('$1')) group by
 node_name

Fred Johanson
TSM Administrator
University of Chicago

773-702-8464

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Thursday, December 06, 2007 7:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select query for nodes in no collocation group

Another approach is:

  select node_name from volumeusage where stgpool_name='________'

to verify if the nodes you expect are actually participating in a
group-collocated storage pool.

Notes:
- Nodes may participate in a group-collocated storage pool and
   not be defined in a collocation group, such that collocation by
   node would then be in effect for such clients, and make for more
   tape use than you might expect.
- The VOLUMEUSAGE table is expensive to search, so do only when
   necessary.

      Richard Sims    at Boston University