SQL Alert Triggered report for last month

mnsh_majumder

Have created this query which will give the details of how many alert got triggered last month. Using Console option gives ambiguous sheet report. Checked with vendor but no proper solution.

SELECT eventtime,message FROM [dbo].[Events] where eventtype='5000' and
message not like '%<name/chosen words for removing unwanted alerts from the report>%'
and
YEAR(eventtime) = DATEPART(yyyy, DATEADD(m, -1, getdate()))
AND
MONTH(eventtime) = DATEPART(m, DATEADD(m, -1, getdate()))

stuartd

If I understand, you are saying the above works but you want to exclude certain alerts with certain words in the message column???

In our case, if I run this and want to exclude our Heartbeat alert, then line 2 would look like this:

message not like '%Heartbeat%'

You don't need the < > and it just confuses SQL, so it ignores it.