Report for triggered alerts past 1 day for 2 specified alerts only

Hi All need help setting up a report for triggered alerts history for past 1 day but only on for the two alerts below

Thanks in advance 

Parents
  • Try this in your Custom Table resource (SQL Query, not SWQL)

    SELECT
    Name 'Alert Name'
    ,EntityCaption 'Object of Alert'
    ,COUNT(1) 'Times Alert Triggered'
    FROM AlertHistoryView
    WHERE EventTypeWord = 'Triggered' AND ((Name = 'Cisco Store Router Down') OR (Name = 'Meraki Device Down (P3)') OR (Name = 'Meraki Device Interface Down (P3)))
    AND TimeStamp > (GETDATE()-1)
    GROUP BY Name, EntityCaption

Reply
  • Try this in your Custom Table resource (SQL Query, not SWQL)

    SELECT
    Name 'Alert Name'
    ,EntityCaption 'Object of Alert'
    ,COUNT(1) 'Times Alert Triggered'
    FROM AlertHistoryView
    WHERE EventTypeWord = 'Triggered' AND ((Name = 'Cisco Store Router Down') OR (Name = 'Meraki Device Down (P3)') OR (Name = 'Meraki Device Interface Down (P3)))
    AND TimeStamp > (GETDATE()-1)
    GROUP BY Name, EntityCaption

Children
No Data