Does anyone have a report which pulls interface IP based on interface custom properties?

I'm in need of a report which shows interface IPs. I would like to include interface custom properties so that it can be filtered based on specific interface custom properties. I can't seem to find the correct combination to pull both interface IP and interface custom properties. NCM reports don't help as many of the devices we have are Fortinet, which NCM isn't monitoring.

Any assistance would be appreciated!

Find more posts tagged with

sql

solarwinds

npm

content_exchange

report

Accepted answers

All comments

bobmarley

The query below should link up the tables for you. Included the Nodes table as well in case you need any info from there.

SELECT top 1000
    [Interfaces].FullName AS InterfaceFullName -- from the Orion.NPM.Interfaces table
,   [Interfaces].PhysicalAddress AS InterfacePhysicalAddress -- from the Orion.NPM.Interfaces table
,   [Interfaces].Node.Caption AS NodesCaption -- Links to the Nodes table in case you want info from that table
,   [Interfaces].CustomProperties.Comments AS CustomPropertiesComments -- Links to the Interface Custom Properties Table, replace comments with your custom property
FROM Orion.NPM.Interfaces

Seashore

Added to @bobmarley ´s query column for IP-address also.

Filtered it to only show IPv4, remove if you don't want that. Also where you can filter on your custom property

SELECT top 100
    I.FullName AS InterfaceFullName 
    ,I.PhysicalAddress AS InterfacePhysicalAddress
    ,I.Node.Caption AS NodesCaption
    ,I.CustomProperties.Comments AS CustomPropertiesComments
    ,I.IPAddress.IPAddress
FROM Orion.NPM.Interfaces AS I
WHERE
    I.IPAddress.IPAddressType='IPv4'
    AND I.CustomProperties.Comments LIKE 'yourfilter'

cfriell

Thank you both for the reply! Much appreciated. I'm working on this with this query. I'm still getting an error message stating "invalid object name "Orion.NPM. Interfaces'. I'm digging in the DB to see if this is the correct table name...

bobmarley

It looks like you have a space in here "Orion.NPM. Interfaces' between NPM and Interfaces, try removing it.