Locating Non-Managed Interfaces

If I wanted to build a report in Crystal Reports (or run a SQL query) to locate which of a certain subset of interfaces I'm not yet monitoring, what criteria would I search on?

For instance, in this case, I'm trying to make sure I'm monitoring the ports for each of our passive AP's, and I want to build a report that tells me if I missed one, and if so what interface and what switch I'm looking for. How would I do that?

Find more posts tagged with

Reports

sql

Database

npm

interface

Accepted answers

All comments

RichardLetts

you will need to be running discovery on the nodes, since interfaces only contains things you are monitoring...

SELECT TOP 1000 di.*FROM discoveredinterfaces di  LEFT OUTER JOIN interfaces i  ON di.discoverednodeid = i.nodeid  AND di.interfaceindex = i.interfaceindexWHERE i.interfaceindex IS NULL  AND di.interfacetype = 6

reports unmonitored discovered ethernet interfaces (join with nodes and query node properties to narrow your result set)