I think this should do what you want: select node_name from nodes where node_name not in (select node_name from filespaces)
David -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Shawn Drew Sent: Monday, August 22, 2016 8:00 PM To: [email protected] Subject: [ADSM-L] Basic select help I am trying to get a list of nodes that have no filespaces and I am getting stuck on what seems to be a very basic select statement. Can someone tell me where I am going wrong? The way I understand it, the select should at least show the node I just created with no filespaces. tsm: TSM1500>reg n shawntest xxxx do=admin userid=none ANR2060I Node SHAWNTEST registered in policy domain ADMIN. tsm: TSM1500>select node_name from nodes where node_name NOT IN (select distinct(node_name) from filespaces) ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11.
