The muted alerts is nice. But who did it? Would be nice to audit this.
You can, See Below
SELECT * FROM AuditingEvents
WHERE ActionTypeID = '100'
I ran that in SQL Studio and it was successful but returned no results. I know I have one on purpose so that I can find how to query or even a report. That's my main goal. Adding the who is not for us but will be for others.
Using AuditEventMessage seems to give more consistent results.
SELECT TOP 1000 * FROM [dbo].[AuditingEvents]
where auditeventmessage like '%mut%'
These are not bad workarounds. But in my environment, they don't show the most recent. Those fell out of scope, beyond the Top XX. I need to show the most recent first as many of the older ones for the query were un-muted some time ago.
Add an:
ORDER BY TimeLoggedUTC
:following the where statement.
This should give you what you're looking for.
This was part of what I was pushing for with , although I should have spelled it out. More people with the same idea serena !
Ahhhhh I see. Thanks for the tag!