Can SolarWinds Track Connected Interface Counts Historically?

k_barton

Hi,

I have always wondered if SolarWinds has the ability to keep track historically of the up/down interface count per node. We all know that SolarWinds can historically keep track of things like interface utilization and errors historically, so I would think that it would be possible.

I have created a query using SWQL that lists the interfaces up & interfaces down. These counts are based on the most recent inventory job that was executed.

Select
n.NodeName,
COUNT (CASE i.OperStatus WHEN 'Up' THEN 1 else NULL end) as [Interfaces Up],
COUNT (CASE i.OperStatus WHEN 'Down' then 2 else NULL end) as [Interfaces Down],
tolocal(n.LastSync) as [Last Sync]

from orion.nodes n
LEFT JOIN ncm.interfaces i on i.Node.CoreNodeID = n.NodeID

where n.nodename like '%NODE_NAME_HERE%'
and i.InterfaceName not like 'Stack%'
and i.interfacename not like 'Nu0'
and i.interfacename not like 'Vl%'
and i.interfacename not like 'Gi0/0'
and i.interfacename not like 'Lo%'
and i.interfacename not like 'Ap%'
and i.Interfacename not like 'Bl%'

GROUP BY n.nodename, n.LastSync

I'd really like to see if it's possible to track this historically and graph it similar to how SolarWinds does with interface utilization.

Thanks

chad.every

This might be handled via the User Device Tracker (UDT) and there are some out of the box resources for it that seem in-line with where you are trying to take your query. NPM is performance based, UDT is connectivity based. More of a switch port mapper that tracks connected endpoints over time.

UDT isn't sold individually any more, but its feature sets are available in the [mention:a84e186fd01942edab9c43c038b14c6c:23b05a61c3e5445190d9bfa00453bce4] license.