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 +, Loon, Eric van (ITOP DI) - KLM wrote:
> Hi everybody,
>
> On one of my servers I'm trying to generate a list of nodes
Subject: [EXTERNAL] [ADSM-L] Listing all nodes without filespaces
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.
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 q