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

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]> [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]<mailto:[email protected]> <[email protected]<mailto:[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 <[email protected]<mailto: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]<mailto:[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<http://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<http://www.td.com/francais/avis_juridique> pour des instructions.
_______________________________________________
TME10 mailing list
[email protected]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto:[email protected]>

_______________________________________________
TME10 mailing list
[email protected]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto: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]<mailto:[email protected]>
Unsubscribe:[email protected]<mailto:Unsubscribe%[email protected]>

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