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.
All supported DX NetOps Performance Management releases
How to answer this depends on a few things.
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.
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;