ncp_perl ncp_polling_exceptions.pl returns no data

Resolving The Problem

The script expects data to be available in two tables under ncmonitor database i.e. ncmonitor.pollLog and ncmonitor.expectedIps.

Here are 2 manual pre-requisites in-order to see the results.

1) Upload the IPs that you want to see them monitored by ITNM. For e.g. if you know complete list of IPs that you want poll, you can put all IPs in a file and run below command:

#$NCHOME/precision/bin/ncp_perl $NHCOME/precision/scripts/perl/scripts/ncp_upload_expected_ips.pl -domain <DOMAINNAME> -file <filename_with_all_IPAddresses>

This will populate ncmonitor.expectedIps table. Note - the script will fail if there are any duplicates in the file and also works strictly on IPv4. Many customers may not have list of IPs that they want to monitor, and such list can be generated from discovered topology using following scripts:

$NCHOME/precision/bin/ncp_perl $NHCOME/precision/scripts/perl/scripts/BuildSeedList.pl -domain <domainName> -outfile <seedfilename>

2) Create a snap shot of current list of IPs that are actively being polled by ITNM:
#$NCHOME/precision/bin/ncp_perl $NHCOME/precision/scripts/perl/scripts/ncp_ping_poller_snapshot.pl -domain <domainname>

This will populate ncmonitor.pollLog table.

3) Once above two steps are complete, run ncp_polling_exceptions.pl to find out IPs that are unmanaged, being polled, out-of-scope etc :
#$NCHOME/precision/bin/ncp_perl $NHCOME/precision/scripts/perl/scripts/ncp_polling_exceptions.pl -domain <domainname> -format report/list.

In summary, its mandatory to feed expected IPs and to create snap shot of currently Polled IPs before you could run ncp_polling_exceptions.pl script.