I've been tasked with creating a report that shows how all of our alerts are created. More to the point we want a report to show the following:
I've found a decent amount of this information, but nothing that completely meets the desired results. Here's that I have so far:
WHEN a.Severity ='2' THEN 'CRITICAL'
WHEN a.Severity ='1' THEN 'WARNING'
END as Severity
FROM Orion.AlertConfigurations a
Join Orion.AlertConfigurationsCustomProperties b on a.AlertID = B.AlertID
WHERE a.Enabled = 'True'
Order by a.Name
I've spent 2 days on this and I'm at an impasse and I need some assistance. Any assistance would be greatly appreciated.