Hi Eric, This should work:
select n.node_name from nodes n left join filespaces f on n.node_name=f.node_name where f.node_name is null On Fri, Mar 03, 2023 at 02:49:20PM +0000, Loon, Eric van (ITOP DI) - KLM wrote: > Hi everybody, > > On one of my servers I'm trying to generate a list of nodes without > filespaces. I know for sure such node exist: > > Protect: >q files LH-PPPC01-DB > ANR2034E QUERY FILESPACE: No match found using this criteria. > ANS8001I Return code 11. > > But if I try to generate this list through a SQL query, it returns no nodes: > > Protect: >select node_name from nodes where node_name not in (select > node_name from filespaces) > ANR2034E SELECT: No match found using this criteria. > ANS8001I Return code 11. > > I don't understand what I'm doing wrong here, has anybody an idea? Thanks for > your help in advance! > > Kind regards, > Eric van Loon > Air France/KLM Core Infra > > ******************************************************** > For information, services and offers, please visit our web site: > https://urldefense.com/v3/__http://www.klm.com__;!!K-Hz7m0Vt54!nuujW6lYNa-NPva2oaAtNWzV-CN6_p_gJWt39S4Kh_MzOKUpZc59lOJxdCFRM6VSrCcdOiwDIlw5aITLt1ngxQ$ > . This e-mail and any attachment may contain confidential and privileged > material intended for the addressee only. If you are not the addressee, you > are notified that no part of the e-mail or any attachment may be disclosed, > copied or distributed, and that any other action related to this e-mail or > attachment is strictly prohibited, and may be unlawful. If you have received > this e-mail by error, please notify the sender immediately by return e-mail, > and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission of > this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department (UW Medicine), System Administrator -- Foege Building S046, (206)-685-7354 -- Pronouns: He/Him/His
