Interface IP address and Subnet table

smalleggo

Anyone know what table the interface IP address and Subnet mask is located in? Everything that I am seeing either goes back to outdated information or gives me the node IP address. Any help would be greatly appreciated. I would think it would be under the "Orion.NPM.Interfaces" table but no luck.

SELECT i.InPercentUtilizationThreshold.CurrentValue AS InPercentUtilizationThreshold_CurrentValue
i.OutPercentUtilizationThreshold.CurrentValue AS OutPercentUtilizationThreshold_CurrentValue
i.CustomProperties.Comments AS CustomProperties_Comments
i.DisplayName
i.Index
round((i.Inbandwidth / 1073741824.0),2) as TotalSize
i.StatusDescription
i.DetailsUrl

FROM Orion.NPM.Interfaces as i

WHERE (i.CustomProperties.Comments LIKE '%XXXX%')

mharvey

The table you are looking for is NodeIPAddresses in SQL or Orion.NodeIPAddresses in SWQL.  You'll want to join via the interfaceindex, but this is the table that contains the ip and subnet information.