Network Utilization of Nodes

Sorry vanities​, I don't understand the use case I'm afraid. What information do you actually expect to see in the output, especially from the Interfaces table? Can you show examples of the different outputs you're seeing?

That query looks very familiar haha

First thing i see is that your join to the interface table looks a bit off, should be like

left join Orion.NPM.Interfaces i on i.nodeid=n.nodeid

I would use a left join because not all nodes have interfaces.

Also, you are not using the icon syntax correctly

"END AS transmit_icon" and "END AS recieve_icon" should be replaced with

end as [_iconfor_transmit]

end as [_iconfor_receive]

Keep in mind that the _iconfor and _linkfor syntaxes are case sensitive regarding the name of the column you are trying to match them against.

Looking a little deeper, it looks like you need to clean up all of the iconfor and linkfor syntaxes

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

•                 LinkedIN: Loop1 Systems
•                 Facebook: Loop1 Systems
•                 Twitter: @Loop1Systems