How to export all nodes' Interface resources?

ArchieG

Hi,

I'd like to export or create a report that shows all Interface resources of all nodes. 

I just need to check which interfaces are/are not monitored on which devices. Is there any way I can see it in one page? 

We have 400 nodes on Solarwinds and it'd be such a pain if I have to click "List Resources" on each node to check monitored interfaces! 

SteveK

So not monitored is going to be your issue.  I want to say that the interfaces will only show up in the database if they are actively being monitored.  So I guess that turns into the conversation of how well you know your environment.

To get a list of monitored interfaces though, I like to pull that from the Nodes table (Orion.Nodes) and go off of the linked Interfaces table (Orion.Nodes.Interfaces routes to Orion.NPM.Interfaces).  That way if you are not monitoring any interfaces on the node, you at least have a row with most of the information being Null.  I'm not sure what data is being captured in your environment, so feel free to remove any of the columns in the query below.  I did have it pull in various information from the node side as well, to make filtering a bit easier.

Select [N].Interfaces.Caption
    , [N].Interfaces.FullName
    , [N].Interfaces.Alias
    , [N].Interfaces.IfName
    , [N].Interfaces.InterfaceName
    , [N].Caption
    , [N].IPAddress
    , [N].Vendor
    , [N].MachineType
From Orion.Nodes [N]