Have you tried the sample script q_nongroupednodes? All the sample scripts
are in the TSM software installation directory in scripts.smp - install with
dsmserv  runfile<path>scripts.smp


DEFINE SCRIPT  Q_NONGROUPEDNODES DESC="Display nodes not in a colloc group"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* ------------------------------------*/"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* Script Name: q_nongroupednodes      */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* Description: Displays the           */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/*  registered nodes that are not      */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/*  currently defined as members       */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/*  of a collocation group, and their  */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/*  domain.                            */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* Parameter: none                     */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* Example: run q_nongroupednodes      */"
UPDATE SCRIPT  Q_NONGROUPEDNODES "/* ------------------------------------*/"
UPDATE SCRIPT  Q_NONGROUPEDNODES "select domain_name as ""Domain"", -"
UPDATE SCRIPT  Q_NONGROUPEDNODES " node_name as -"
UPDATE SCRIPT  Q_NONGROUPEDNODES " ""Nodes not defined to collocation
group"" -"
UPDATE SCRIPT  Q_NONGROUPEDNODES " from nodes where collocgroup_name is -"
UPDATE SCRIPT  Q_NONGROUPEDNODES " null order by domain_name, node_name"


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary
Sent: September 11, 2014 04:51
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] sql question

I have run myself ragged on this one.
I would have sworn it worked yesterday morning.

Tsm server 6.2.5 under RHEL 6.1

I am trying to get a list of nodes not in a collocgroup.
Statement follows:

Select a.node_name from nodes a where
a.node_name not in (select b.node_name from collocgroup b)

Thanks foor any assistance.
Its probably simple, and I'm just not seeing it.