2 Replies Latest reply on Aug 19, 2015 3:55 AM by Selspiero

    Report to show all nodes that have breached a threshold

    Selspiero

      Hi there,

       

      I would like to create a report that shows all nodes that have breached their CPU threshold in the last week. We have an alert that fires if they sustain their breach for 10 minutes if that helps.

       

      Thanks!

        • Re: Report to show all nodes that have breached a threshold
          zackm

          Assuming that you have NPM 11.5 or later, you should be able to accomplish something like this:

           

          1) Find your AlertID for the CPU Alert you mentioned (You can query the database with this)

           

          SELECT AlertID, Name
          FROM AlertConfigurations
          WHERE Enabled = 1
          ORDER BY AlertID
          
          
          
          
          
          
          
          
          
          
          
          
          

           

          2) Once you have your AlertID, you can then go to your Orion Website and navigate to the "Manage Reports" section and then click "Create New Report"

           

          3) Now, to set your data source, you want to use the "Alert History" object type and then add 2 limitations for AlertObject.AlertID and AlertHistory.EventType

              - AlertObject.AlertID = the AlertID value you found in Step 1

              - AlertHistory.EventType = 0 (this returns only events where the alert was triggered)

          2015-08-18_21-10-40.gif

           

          4) Now, to select your table columns, you want to grab AlertHistory.TimeStamp, AlertHistory.AlertHistoryID, and AlertObject.EntityCaption

              - AlertHistory.TimeStamp = you want to hide this column from the result set, we are simply using this  to provide a metric for time limitation

              - AlertHistory.AlertHistoryID = you want to rename this column title to something like "Times Fired" and set you data aggregation to "COUNT"

              - AlertObject.EntityCaption = you  can rename this to something like "Device Name"

              ***You also want to set your time-based options to "YES" and do not summarize your results

          2015-08-18_21-24-49.gif

           

          5) Once you have your table set, you will be back at the main design page, make sure you change the time drop down next to your data source to whatever limitation you want and then proceed as normal.

          2015-08-18_21-27-46.gif

           

          6) Your end result should look like this:

          2015-08-18_21-28-38.gif

           

           

          Hope that helps!

           

          -ZackM

          Loop1 Systems: SolarWinds Training and Professional Services