I want to create a SAM report that will show all assigned Application Templates and a list of Alerts that each assigned Application Template could trigger. Also, keep in mind that each monitoring component in the Application Template could trigger different Alerts.
This is probably very simple. But I’m getting a brain block on it.
I don’t need help with everything. The SWQL/SQL expressions and/or logic would be much appreciated.
The report format could look something like this:
Name of assigned Application Monitor 1
Alert Name 1
Alert Name 2
Alert Name 3
Name of assigned Application Monitor 2
Alert Name 1
Name of assigned Application Monitor 3
I’m open to any suggestions.
I've been running this query to find applications we are alerting on and which components:
select ao.AlertID, apm.Name as Application, ac.Name as Alert, apc.Name as Component
from AlertConfigurations ac
join AlertObjects ao on ao.AlertID = ac.AlertID
join APM_Application apm on apm.Uri = ao.EntityUri
join APM_Component apc on apc.ApplicationID = apm.ID
where ac.ObjectType like '%Application%' and ac.Enabled like '1'
Order by ac.Name, apm.Name
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.