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
Hi Eric,
Try this:
select node_name from nodes where node_name not in (select node_name from
filespaces where node_name is not null)
Regards,
Art
From: ADSM: Dist Stor Manager on behalf of Loon, Eric
van (ITOP DI) - KLM
Date: Friday, March 3, 2023 at 9:52 AM
To: ADSM-L@VM.MARIST.EDU
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
