Assigned Alerts for Components Template

Hi Team,

Need a report on assigned alerts on each application and component i have a query for Application, Could you please help to modify the below query for components?

Application Template:

select ao.AlertID, apm.Name as Application, ac.Name as Alert
from AlertConfigurations ac
join AlertObjects ao on ao.AlertID = ac.AlertID
join APM_Application apm on apm.Uri = ao.EntityUri
where ac.ObjectType like '%Application%' and ac.Enabled like '1'
Order by ac.Name, apm.Name

Thanks,

Srikanth.

Find more posts tagged with

sam

Component

SWQL

sql query

Accepted answers

All comments

gattadisrikanth

FYI Plese find the below screenshot for applications the same way i need for component.

Seashore

If I understand your wish correct you don't get what you want from your query and that is not how orion works.

As I understand you want a report on each alert rule that can trigger alerts on each application (and also components later on). But there are no such mapping in Orion.

You are joining in [AlertObjects] to get out all applications but only objects that has already triggered an alert is added to that table. Applications that never have triggered and alert will not show up in this report.

I would also advice against having individual alert rules for each application but instead having generic alert rules that triggers on all application issues. Managing all these rules is hard and it's easy to miss things that should be alerted on.

gattadisrikanth

Hi Seashore,

Thanks for your reply.

what i am looking for this if i search in manager alerts like "application" type As porperty to monitor i am getting the same in report and manager alerts

Below and above the same: with the query which i shared

The same Way i am looking for if i search component in manager alerts we should get the Component details.

In the report with alert name and component.

How can we export the report for below alerts and componets Type.

Seashore

SELECT 
    ac.AlertID AS [AlertRuleID]
    ,ac.Name as [AlertRuleName]

FROM Orion.AlertConfigurations AS ac
WHERE 
    ac.ObjectType = 'APM: Component' 
    --AC.ObjectType = 'APM: Application'
    AND ac.Enabled = 1
Order by ac.Name

Hi, this SWQL code gives you all alert rules that looks for components. You can also just change the lines 7 and 8 to get application alerts instead of component alerts.

Above is SWQL not, SQL, Solarwinds Query Language. Works just as good when you create reports in Orion.

As you see I have NOT included AlertObjects, applications or components table as that will give you the wrong info, in my opinion.

Hope it helps

gattadisrikanth

Thanks Sir,

this helps me but i cant see the alert name i can see only Alert ID

can we get the alert name as well?