Performance Management Inventory Audit

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The ask from operations is to report on devices discovered into CAPM, via sync with Spectrum, that are not reporting SNMP.

They are looking for a bulk approach to review, instead of review device dashboards.

How to list out devices present in the DX NetOps Performance Management Performance Center Inventory that are synchronized from Spectrum but not discovered and polling with SNMP from the Data Aggregator.

Spectrum synchronized devices in Performance Center that are not being SNMP Polled.

Environment

All supported DX NetOps Performance Management releases

Resolution

How to answer this depends on a few things.

• All IPs synced from Spectrum to Performance Center in the environment are being sent to the Data Aggregator for SNMP Discovery.
  • Check the Spectrum Data Source configuration. See if the "Contribute inventory to Data Aggregator" option is enabled.
• The IPs are added to the Discovery Profile named after the IP Domain they are synced over to per the Domain based GC in Spectrum.
  • For example if a device is added to the Spectrum GC named Default Domain, the IP is added to the Default Domain Discovery Profile.
  • If the Default Domain Discovery Profile is set to allow creation of Pingable items:
    • If the device responds to Ping but fails to respond to SNMP, a Pingable item will be created for it.
    • If the device fails to respond to both Ping and SNMP it will be left in the Discovery Profile. It will try discovering that IP every time the Discovery Profile runs until success is found via Ping and/or SNMP.
    • If the Default Domain Discovery Profile is set so it does NOT allow creation of Pingable items:
  • If it fails SNMP communications the IP is left in the Discovery Profile IP list to be tried again each time it runs until success is achieved.

How to determine which devices those are then becomes a mixed set of results. We would need to see what items are Pingable, or review items left in the Discovery Profile IP list.

If you wish to find Spectrum only devices (aka those not discovered via SNMP in the DA), run the mysql below.

NOTE: Unknown is calculated on the fly by seeing there is no reach_rate (Reachability as polled data) for a device. Not something we can find via query in PC.

1. Connect to the PC MySql DB CLI. Go to (default path) /opt/CA/MySql/bin.
2. First run this to ID the SourceID values for the Spectrum and Data Aggregator Data Sources.
   1. select SourceID,SourceType,ConsoleName from netqosportal.data_sources2;
3. Take the SourceID for the Spectrum and Data Aggregator Data Sources and run this query.
   1. select itemname, v6_ntoa(address) from dst_device where sourceid=<Spectrum_SourceID> and itemid not in (select itemid from dst_device where sourceid =<DA_SourceID>) order by 1;

For example if I have a Data Aggregator with SourceID=3, and Spectrum SourceID=8 the second query would be:

select itemname, v6_ntoa(address) from dst_device where sourceid=8 and itemid not in (select itemid from dst_device where sourceid=3) order by 1;