2 Replies Latest reply on Oct 17, 2017 8:42 AM by donkeykong

    RowsPerPage on All Active Alerts

    donkeykong

      Hello Thwack members,

       

      I have been using Solarwind's NPM and SAM for some time and would like to know if it is possible to change the maximum number of rows of active alarms from 5 to XX?

      I know this went with an outdated version of Solarwinds using the All Triggered Alerts table. There, in a JavaScript file, the RowsPerPage attributes could be adjusted from 5 to XX.

       

      This has only worked because this object was a "Custom Query Table".

       

       

      I hope this is possible.

      I would appreciate an answer.

      Many thanks in advance.

        • Re: RowsPerPage on All Active Alerts
          mesverrum

          To get around that issue I created a custom query that does the job and you can set as many lines as you like,  you can also make it searchable which is nice.

           

           

          SELECT
          o.AlertConfigurations.Name AS [ALERT NAME]
          ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME]
          ,CASE
          WHEN o.AlertConfigurations.Severity = 2 THEN '/Orion/images/ActiveAlerts/Critical.png'
          WHEN o.AlertConfigurations.Severity = 3 THEN '/Orion/images/ActiveAlerts/Serious.png'
          WHEN o.AlertConfigurations.Severity = 1 THEN '/Orion/images/ActiveAlerts/Warning.png'
          WHEN o.AlertConfigurations.Severity = 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png'
          WHEN o.AlertConfigurations.Severity = 4 THEN '/Orion/images/ActiveAlerts/Notice.png'
          END AS [_iconfor_ALERT NAME]
          ,o.EntityCaption AS [ALERT OBJECT]
          ,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT]
          ,case
          WHEN o.RelatedNodeCaption=EntityCaption THEN 'Self'
          When o.RelatedNodeCaption!=EntityCaption THEN RelatedNodeCaption
          End as [RELATED NODE]
          ,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE]
          ,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME]
          -- ,o.AlertActive.TriggeredMessage AS [ALERT MESSAGE]
          --,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_ALERT OBJECT]
          ,'/Orion/images/StatusIcons/Small-' + p.StatusIcon AS [_IconFor_RELATED NODE]
          ,CASE
          when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>1440 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/1440.0,1)) + ' Days')
          when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>60 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/60.0,1)) + ' Hours')
          else (tostring(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())) + ' Minutes')
          end as [Time Active]
          ,aa.AcknowledgedBy
          ,ah.Message as [Note]
          
          From Orion.AlertActive aa
          join Orion.AlertObjects o on aa.alertobjectid=o.alertobjectid
          LEFT join Orion.Nodes p on p.nodeid=relatednodeid
          left join orion.alerthistory ah on ah.AlertActiveID=aa.AlertActiveID and ah.EventType in (2,3)
          
          --where (o.AlertConfigurations.Name like '%${SEARCH_STRING}%' or o.RelatedNodeCaption like '%${SEARCH_STRING}%' or o.EntityCaption like '%${SEARCH_STRING}%' or ah.Message like '%${SEARCH_STRING}%')
          
          ORDER by o.AlertActive.TriggeredDateTime DESC

           

          -Marc Netterfield

              Loop1 Systems: SolarWinds Training and Professional Services