2 Replies Latest reply on Jan 22, 2014 10:49 AM by tisonet

    Interface utilization and CPU utilization in the same chart

    glenn.thomas@adp.com

      Has anyone had any luck creating a single graph that includes Interface utilization for a specific interface and also report on CPU utilization in the SAME chart?  I know we have the ability to use Multiple object chart but it appears only nodes OR interfaces can be selected.  Thoughts?

       

      -Glenn

        • Re: Interface utilization and CPU utilization in the same chart
          tisonet

          Hi,

           

          in NPM 10.6 you can use Custom Chart resource, which is available on report. So you have to create report with custom chart resource.

           

          1)  Goto manage reports page and click on 'Create New Report'

          2) In Add Content dialog select 'Custom Chart'

          3) In Selection Method choose 'Advanced Data Base Query (SQL, SWQL)'

          4) Write your SWQL query. I created example

           

          SELECT ID, CAPTION, DATETIME, CPU_UTIL, INTERFACE_UTIL

          FROM

          (

          SELECT NodeID AS ID, N.Node.Caption AS CAPTION, DateTime, AvgLoad AS CPU_UTIL, NULL AS INTERFACE_UTIL

          FROM Orion.CPULoad N

          WHERE NodeID = 737 -- set yours nodeId

           

          UNION ALL

          (

          SELECT InterfaceID AS ID, I.Interface.Caption AS CAPTION, DateTime, NULL AS CPU_UTIL, PercentUtil AS INTERFACE_UTIL

          FROM Orion.NPM.InterfaceTraffic I

          WHERE InterfaceID = 16 -- set yours interfaceId

          ))

           

          5) Click to 'Add to layout'. You will be redirected on Chart edit page.

          6) Configure chart the same as on screenshots and submit it.

          7) Finish report wizard.

           

          1.PNG

          2.PNG

          3.PNG

          4.PNG

            • Re: Interface utilization and CPU utilization in the same chart
              tisonet

              TIP:

               

              You can use modified SWQL query and use only one Y-axis.

               

              SELECT ID, CAPTION, DATETIME, UTIL

              FROM

              (

              SELECT NodeID AS ID, N.Node.Caption AS CAPTION, DateTime, AvgLoad AS UTIL

              FROM Orion.CPULoad N

              WHERE NodeID = 737 -- set yours nodeId

               

              UNION ALL

              (

              SELECT InterfaceID AS ID, I.Interface.Caption AS CAPTION, DateTime, PercentUtil AS UTIL

              FROM Orion.NPM.InterfaceTraffic I

              WHERE InterfaceID = 16 -- set yours interfaceId

              ))

               

              6.PNG