This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Interface utilization and CPU utilization in the same chart

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

  • 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

  • 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