Create Report for Discovered Interfaces

Question

Guys,

Could someone please guide me on which table I can use to list all interfaces not selected in "List Resources" using SWQL? I tried on Orion.NPM.Interfaces and Orion.DiscoveryIgnoredInterfaces table, but it does not show what I'm looking for. The goal is to create a Weekly report that lists all interfaces that are not being monitored. I appreciate any help you can provide.

vinay.by · Accepted Answer

You can't do this, but then you can actually try this rather - Create a scheduled discovery in your environment to scan your infrastructure on a monthly basis - but be careful it shouldn't overload your SolarWinds environment. Don't select add it automatically when you create a discovery. You can always look at the results in Scheduled Discovery results tab on Network Discovery - this tab can show you what isn't added in your environment, but then this also depends on what is set in your discovery rule - hence draft that accurately. Hope this helps.

documentation.solarwinds.com/.../core-network-discovery-using-the-network-sonar-wizard-sw1574.htm

__PRESENT__PRESENT__PRESENT

stuartd · Accepted Answer

No. They are shown to you via a on the fly SNMP get query.

@vinay.by confirmed what I thought. I was 99% certain the non-connected details are not stored in the DB and therefore you can't create a report for them