Within a production environment it is desirable to identify what ITNM poll policies are monitoring what devices. Thankfully enough ITNM provides this functionality as one of the many canned reports that ship with the product.  However, how do you get access to that information if for reasons beyond your control you do not have access to the Tivoli Integrated Portal?  This conundrum can be solved by accessing the required data directly from the NCIM database using a command line.

This brief article will detail the process required to access the NCIM database (as delivered by ITNM v3.9) on a MySQL database to gain access the required information.

From a terminal with access to the MySql database login with the required permissions (mysql –u<USERNAME> -p<PASSWORD> -h<HOSTNAME>) to access the ncpolldata database (use ncpolldata).  The ncpolldata database contains details of all polls active whether they store data or not. Enter the following command to display the monitoring information:-

SQLimage

This displays all devices that are in a particular domain.  It is important to note that <ITNMDOMAIN> placeholder is replaced with a valid ITNM domain at runtime. 

The above command can be placed into a simple text file which can be used as input and then the result piped to another file (called <RESULT_FILE>) by utilising the following command:-

mysql –u<USERNAME> -p<PASSWORD> -h<HOSTNAME> -Dncpolldata <  <SQL_FILE ><RESULT_FILE>

 

A sample of the result file is displayed.

SQLresult1

 

To provide a further level of detail, for instance an operator is only interested in the ICMP polls within the network the query can be tweaked to display only the ping polls. Enter the following command to display information about both the chassis and interface polls:-

SQL2

This displays all devices that are being monitored by the standard ICMP polling mechanism provided by ITNM.

Yet again the command can be placed into a simple text file to execute via the command line with the following command:-

mysql –u<USERNAME> -p<PASSWORD> -h<HOSTNAME> -Dncpolldata <  <SQL_FILE>  >  <Result_File>

A sample of the result file is displayed.

SQLresult2

By This email address is being protected from spambots. You need JavaScript enabled to view it.

Twitter Feed

OrbData Is your company ready for #GDPR? https://t.co/fGybdNrlCh
OrbData Setting up Windows PowerShell discoveries with #IBM #TADDM https://t.co/pxMZ2eVPpo

Address

Address:
100 Longwater Avenue, Green Park, Reading, RG2 6GP, U.K.
Tel:
+44 (0) 118 945 0130
E-Mail:
This email address is being protected from spambots. You need JavaScript enabled to view it.

markerFind on Google Maps

About Us

Orb Data brings together People, Process and Technology to deliver the cornerstone of business success: the management of IT infrastructure. At our heart are our people. We have unrivalled experience, helping us to achieve an enviable reputation for excellence in project delivery. Because we’re independent, we identify actual issues and help organisations resolve them –from spec to deployment, and beyond –providing the right solution in terms of best of breed technology and support. We offer a refreshingly simple approach to the way we conduct business. We take pride in our abilities to provide first class solutions to business problems, and to conduct working relationships with honesty and integrity.

Follow Us On:

JoomShaper