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:[email protected]] On Behalf Of Nick Marouf Sent: Thursday, September 11, 2014 8:08 AM To: [email protected] 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 <[email protected]> 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. >
