Re: [ADSM-L] sql question
2014-09-11 11:51:45
Have you tried the sample script q_nongroupednodes? All the sample scripts
are in the TSM software installation directory in scripts.smp - install with
dsmserv runfile<path>scripts.smp
DEFINE SCRIPT Q_NONGROUPEDNODES DESC="Display nodes not in a colloc group"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* ------------------------------------*/"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* Script Name: q_nongroupednodes */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* Description: Displays the */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* registered nodes that are not */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* currently defined as members */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* of a collocation group, and their */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* domain. */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* Parameter: none */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* Example: run q_nongroupednodes */"
UPDATE SCRIPT Q_NONGROUPEDNODES "/* ------------------------------------*/"
UPDATE SCRIPT Q_NONGROUPEDNODES "select domain_name as ""Domain"", -"
UPDATE SCRIPT Q_NONGROUPEDNODES " node_name as -"
UPDATE SCRIPT Q_NONGROUPEDNODES " ""Nodes not defined to collocation
group"" -"
UPDATE SCRIPT Q_NONGROUPEDNODES " from nodes where collocgroup_name is -"
UPDATE SCRIPT Q_NONGROUPEDNODES " null order by domain_name, node_name"
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary
Sent: September 11, 2014 04:51
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] sql question
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.
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
Re: [ADSM-L] sql question,
J. Pohlmann <=
|
|
|