Discover which ITNM poll policies are monitoring which devices

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 Neil Richards