Open for Voting

Reports showing Baseline information

The baseline threshold information you can view interactively either in NPM (cpu, ram, IO) is useful beyond just setting thresholds.

I'd like to see a report option where you can select a metric or set of metrics (again - CPU, RAM, IO, etc) and a node limitation (by built-in or custom property) and then display a report that provides the following for each node:

  • a chart of the last 7 days
  • the 7 day average
  • The sigma value
  • The range of -3 through +3 sigma for day, night, and all
adatole
  • in reply to jamison.jennings

    Amazing work!!

    You should bundle this up into a .OrionReport file and post it to the ContentExchange. Those Thwack points don't grow on trees, you know!

  • I've managed to come up with this until they get it in like you requested adatole‌

    Insert these SQL Queries in a Orion Report Writer, then Insert them via "Report from Orion Report Writer" on Node Details Page.

    CPU:

    SELECT   CASE ([TimeFrameID])

          When '4' Then 'All Hours'

          When '5' Then 'Work Day'

          When '6' Then 'Evenings and Weekends'

          Else 'Other'

          END AS "Time Period"

      ,ROUND([AvgLoadMin],2) AS "MIN"  ,ROUND([AvgLoadMax],2) AS "MAX"  ,ROUND([AvgLoadStDev],2) AS "STD DEV (s)"  ,ROUND([AvgLoadMean] - 3 * [AvgLoadStDev],2) AS "-3s"

          ,ROUND([AvgLoadMean] - 2 * [AvgLoadStDev],2) AS "-2s"

          ,ROUND([AvgLoadMean] - 1 * [AvgLoadStDev],2) AS "-1s"

          ,ROUND([AvgLoadMean],2) AS "MEAN"

          ,ROUND([AvgLoadMean] + 1 * [AvgLoadStDev],2) AS "1s"

          ,ROUND([AvgLoadMean] + 2 * [AvgLoadStDev],2) AS "2s"

      ,ROUND([AvgLoadMean] + 3 * [AvgLoadStDev],2) AS "3s"

          FROM [dbo].[CPULoad_Statistics]

      where NodeID ='${Nodeid}'

    MEMORY:

    SELECT   CASE ([TimeFrameID])

          When '4' Then 'All Hours'

          When '5' Then 'Work Day'

          When '6' Then 'Evenings and Weekends'

          Else 'Other'

          END AS "Time Period"

      ,ROUND([AvgPercentMemoryUsedMin],2) AS "MIN"  ,ROUND([AvgPercentMemoryUsedMax],2) AS "MAX"  ,ROUND([AvgPercentMemoryUsedStDev],2) AS "STD DEV (s)"  ,ROUND([AvgPercentMemoryUsedMean] - 3 * [AvgPercentMemoryUsedStDev],2) AS "-3s"

          ,ROUND([AvgPercentMemoryUsedMean] - 2 * [AvgPercentMemoryUsedStDev],2) AS "-2s"

          ,ROUND([AvgPercentMemoryUsedMean] - 1 * [AvgPercentMemoryUsedStDev],2) AS "-1s"

          ,ROUND([AvgPercentMemoryUsedMean],2) AS "MEAN"

          ,ROUND([AvgPercentMemoryUsedMean] + 1 * [AvgPercentMemoryUsedStDev],2) AS "1s"

          ,ROUND([AvgPercentMemoryUsedMean] + 2 * [AvgPercentMemoryUsedStDev],2) AS "2s"

      ,ROUND([AvgPercentMemoryUsedMean] + 3 * [AvgPercentMemoryUsedStDev],2) AS "3s"

          FROM [dbo].[CPULoad_Statistics]

      where NodeID ='${Nodeid}'

    Transmit Interface Utilization Baseline Statistics: (Insert this Orion Report into Interface Details page)

    SELECT   CASE ([TimeFrameID])

          When '4' Then 'All Hours'

          When '5' Then 'Work Day'

          When '6' Then 'Evenings and Weekends'

          Else 'Other'

          END AS "Time Period"

      ,ROUND([Out_PercentUtilMin],2) AS "MIN"  ,ROUND([Out_PercentUtilMax],2) AS "MAX"  ,ROUND([Out_PercentUtilStDev],2) AS "STD DEV (s)"  ,ROUND([Out_PercentUtilMean] - 3 * [Out_PercentUtilStDev],2) AS "-3s"

          ,ROUND([Out_PercentUtilMean] - 2 * [Out_PercentUtilStDev],2) AS "-2s"

          ,ROUND([Out_PercentUtilMean] - 1 * [Out_PercentUtilStDev],2) AS "-1s"

          ,ROUND([Out_PercentUtilMean],2) AS "MEAN"

          ,ROUND([Out_PercentUtilMean] + 1 * [Out_PercentUtilStDev],2) AS "1s"

          ,ROUND([Out_PercentUtilMean] + 2 * [Out_PercentUtilStDev],2) AS "2s"

      ,ROUND([Out_PercentUtilMean] + 3 * [Out_PercentUtilStDev],2) AS "3s"

      FROM [dbo].[InterfaceTraffic_Statistics]

      where interfaceid ='${InterfaceID}'

    Receive Interface Utilization Baseline Statistics: (Insert this Orion report into Interface Details Page)

    SELECT   CASE ([TimeFrameID])

          When '4' Then 'All Hours'

          When '5' Then 'Work Day'

          When '6' Then 'Evenings and Weekends'

          Else 'Other'

          END AS "Time Period"

      ,ROUND([In_PercentUtilMin],2) AS "MIN"  ,ROUND([In_PercentUtilMax],2) AS "MAX"  ,ROUND([In_PercentUtilStDev],2) AS "STD DEV (s)"  ,ROUND([In_PercentUtilMean] - 3 * [In_PercentUtilStDev],2) AS "-3s"  ,ROUND([In_PercentUtilMean] - 2 * [In_PercentUtilStDev],2) AS "-2s"  ,ROUND([In_PercentUtilMean] - 1 * [In_PercentUtilStDev],2) AS "-1s"  ,ROUND([In_PercentUtilMean],2) AS "MEAN"  ,ROUND([In_PercentUtilMean] + 1 * [In_PercentUtilStDev],2) AS "1s"  ,ROUND([In_PercentUtilMean] + 2 * [In_PercentUtilStDev],2) AS "2s"  ,ROUND([In_PercentUtilMean] + 3 * [In_PercentUtilStDev],2) AS "3s"

      FROM [dbo].[InterfaceTraffic_Statistics]

      where interfaceid ='${InterfaceID}'

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.