This should do the trick for you. All of the following is based on NPM polling, no NCM data is being used here.
First, you want to use the Web Report GUI to create a new report and setup your datasource to look for any Interfaces that have traffic and are either Up or Down.
Then, you want to edit your table colums as such: (make sure you set your time-based settings to "No")
- Node.Caption to get the device name
- Interface.Caption for the interface name (I added a status led to the display settings here)
- InterfaceTrafficHistory.Timestamp to get the latest time traffic was received. (Using the MAX data aggregation option)
That will get you a report like such (device and interface names redacted here)
For reference, this SQL query returns the same information:
select n.caption as 'Device' ,i.caption as 'Interface' ,max(t.datetime) as 'Last Traffic Received' from interfacetraffic t join nodes n on n.nodeid = t.nodeid join interfaces i on i.interfaceid = t.interfaceid where in_minbps <> 0 and out_minbps <> 0 group by n.caption, i.caption order by n.caption, i.caption
Loop1 Systems: SolarWinds Training and Professional Services
I cannot thank you enough. I Hope I can pass on the favor someday.
The dynamic query builder is there when I duplicate and edit a report so I am just not locating it when creating a new report. I'll get there. Sorry.