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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Shawn Drew
Sent: Monday, August 22, 2016 8:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
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.