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.

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