RE: How to seperate AIX, Solaris or HP for ux agent

If the search string was not at the start of HOSTINFO

SELECT NODE,HOSTINFO,PRODUCT FROM O4SRV.INODESTS WHERE HOSTINFO LIKE 
'*AIX*' AND PRODUCT LIKE 'UX';

in LIKE you can use MS_DOS wild cards - asterisk [*] and question mark [?] 
to match any number of characters [*] or match any single character [?].

Regards, 

  



John Alvord - Ph: 1-720-396-2788    Cell: none 
Customer Support - Tivoli Software - jalvord-r/[email protected]
Advisory Engineer - Tivoli Monitoring - ITM infrastructure
Developer Blog - Wonderful World of Situations
Follow us on Twitter! @Tivolisupport and Facebook
Personalize your support needs with the IBM Support Portal
Use Service Request to get assistance!
For emails regarding a PMR, copy [email protected]
For secure browser uploads: https://www.ecurep.ibm.com/app/upload
For Customer Support guidance: IBM Software Support Handbook









From:   "Liu, Jun Feng" <[email protected]>
To:     "Discussion list for Tivoli product and Tivoli Ready products." 
<[email protected]>, 
Date:   04/26/2013 12:04 PM
Subject:        RE: [TME10] How to seperate AIX, Solaris or HP for ux 
agent
Sent by:        [email protected]



I think this is the easiest way from teps to create sql like below
 
SELECT NODE,HOSTINFO,PRODUCT FROM O4SRV.INODESTS WHERE HOSTINFO LIKE 'AIX' 

AND PRODUCT LIKE 'UX';
 
Thanks
 
Jun Feng Liu
 
TD| Enterprise IT Operations (EITO) I Monitoring Tools Services 

SOC: (416) 983-9293 | C: (416) 428-4932
 
 
 
http://w4.oam.td.com/oar/monitoring/client/Pages/Default.aspx

 
 
From: [email protected] [
mailto:[email protected]] On Behalf Of Liu, Jun Feng
Sent: Friday, April 26, 2013 1:59 PM
To: Discussion list for Tivoli product and Tivoli Ready products.
Subject: RE: [TME10] How to seperate AIX, Solaris or HP for ux agent
 
Cool,  thanks all
 
I will try that.
 
Have a nice weekend, folks
 
 
Thanks
 
Jun Feng Liu
 
TD| Enterprise IT Operations (EITO) I Monitoring Tools Services 

SOC: (416) 983-9293 | C: (416) 428-4932
 
 
 
http://w4.oam.td.com/oar/monitoring/client/Pages/Default.aspx

 
 
From: [email protected] [
mailto:[email protected]] On Behalf Of Venkat Saranathan
Sent: Friday, April 26, 2013 1:57 PM
To: Discussion list for Tivoli product and Tivoli Ready products.
Subject: Re: [TME10] How to seperate AIX, Solaris or HP for ux agent
 
Just expanding on the ideas Toben and IV suggested, you can use "gbscmd 
executesql" to run the SOAP call.
 
Here is an example.
 
perl gbscmd executesql --auth itm63.auth --sql "SELECT NODE,HOSTINFO FROM 
O4SRV.INODESTS WHERE PRODUCT = 'UX'"
 
Hope this helps,
 
 

with warm regards,
Venkat Saranathan
Gulf Breeze Software
 
Gulf Breeze Calculus: We differentiate our work in Tivoli Integration!
 
On Fri, Apr 26, 2013 at 10:50 AM, [email protected] <
[email protected]> wrote:
Jun:  To add to I.V.'s answer in case you're not familiar with CLI-based 
SOAP for ITM, you can also have the TEPS UI do the work for you.  Just 
create a new custom SQL query using the TEMS data source which does:

SELECT NODE,HOSTINFO FROM O4SRV.INODESTS;
Assign to a view and add some filters on the HostInfo column in order to 
eliminate blank, but not null, values:
Win*
AIX*
Linux*
Sun*
The reason I don't use "Scan for a string within a string" on the values 
and omit the asterisks is that you want only those columns which start 
with the above strings, not those which contain them anywhere.
Toben
 
On Fri, Apr 26, 2013 at 9:19 AM, I.V. Blankenship <
iv.blankenship-9LkaxTQlAnxWk0Htik3J/[email protected]> wrote:
You could do a soap call that runs some SQL selecting node name and osinfo 

then grep for the various patterns.

On Apr 26, 2013, at 10:08 AM, "Liu, Jun Feng" <[email protected]> wrote:
Hi, folks
 
What is the easy way to separate ux agent for Solaris, HP or AIX from 
command line?
 
 
 
Thanks
 
Jun Feng Liu
=

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to 
www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, 
prière d'aller au www.td.com/francais/avis_juridique pour des 
instructions.
_________________________
______________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]

_________________________
______________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]


-- 
"Sometimes I think that's the only right thing to do:
To dream. to live in the world of dreams.
But it doesn't last forever--wakefulness always comes to take me back..." 

_________________________
______________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]
 _______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]

_______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]