2 Replies Latest reply on Jun 22, 2017 8:55 PM by vanities

    Network Utilization of Nodes

    vanities

      real neato I cant delete a post

        • Re: Network Utilization of Nodes
          Michael Halpin

          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?

          • Re: Network Utilization of Nodes
            mesverrum

            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