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
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
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
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
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.