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:[email protected]] On Behalf Of Lee, Gary Sent: September 11, 2014 04:51 To: [email protected] 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.
