[ADSM-L] sql question

ADSM-L

[Top] [All Lists]

[ADSM-L] sql question

2014-09-11 07:52:57

Subject:	[ADSM-L] sql question
From:	"Lee, Gary" <GLEE AT BSU DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Thu, 11 Sep 2014 11:51:03 +0000

I have run myself ragged on this one.
I would have sworn it worked yesterday morning.

Tsm server 6.2.5 under RHEL 6.1

I am trying to get a list of nodes not in a collocgroup.
Statement follows:

Select a.node_name from nodes a where
a.node_name not in (select b.node_name from collocgroup b)

Thanks foor any assistance.
Its probably simple, and I'm just not seeing it.

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] sql question, Lee, Gary <= Re: [ADSM-L] sql question, Nick Marouf Re: [ADSM-L] sql question, Lee, Gary Re: [ADSM-L] sql question, William Sefranek Re: [ADSM-L] sql question, Lee, Gary Re: [ADSM-L] sql question, Andrew Raibeck Re: [ADSM-L] sql question, J. Pohlmann

Previous by Date:	[ADSM-L] Spectra T-Finity/TS1140/TSM 6.3/RHEL6, Tom Tann{s
Next by Date:	Re: [ADSM-L] sql question, Nick Marouf
Previous by Thread:	[ADSM-L] Spectra T-Finity/TS1140/TSM 6.3/RHEL6, Tom Tann{s
Next by Thread:	Re: [ADSM-L] sql question, Nick Marouf
Indexes:	[Date] [Thread] [Top] [All Lists]