Re: [ADSM-L] sql question
2014-09-11 08:19:58
Nick:
Just tried a cut and paste directly into the admin client.
Same results,
Anr2034E no results match this criteria
However, a select count(node_name) from collocgroup gives 74
And select count(*) from nodes gives 196
I'm baffled
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Nick Marouf
Sent: Thursday, September 11, 2014 8:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] sql question
Hi,
It seems to work ok for me, I added a "-" for continuation. TSM on 6.3.0 on
AIX 7, and TSM 6.3.4 on Redhat 5 and 6
Select a.node_name from nodes a where -
a.node_name not in (select b.node_name from collocgroup b)
On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary <GLEE AT bsu DOT edu> wrote:
> 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.
>
|
|
|