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.

SWQL or SQL report help

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:

  • The scope of the alert
  • The trigger condition
  • The reset condition
  • All trigger actions
    • Who's being notified and the message body.
  • All reset actions
    • who's being notified and the message body.

I've found a decent amount of this information, but nothing that completely meets the desired results.  Here's that I have so far:

SELECT

  a.Name

, a.Description

, a.ObjectType

, a.Frequency

, CASE

   WHEN a.Severity ='2' THEN 'CRITICAL'

   WHEN a.Severity ='1' THEN 'WARNING'

END as Severity

, a.Trigger

, a.Reset

, a.AlertMessage

, a.NotifyEnabled

, a.NotificationSettings

, a.Canned

, b.ResponsibleTeam

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.