Report For Any Alerts Using Custom Properties?

Hey All,

We're looking to overhaul how we utilize custom properties for alerting but wanted to make sure any changes we intend to make won't negatively affect our alerts. Is there any way to create a report or DB query to identify any alerts that are using any custom properties as part of their trigger conditions etc?

Find more posts tagged with

custom_properties

Alert

Alerts

custom-properties

Accepted answers

All comments

monitoringlife

Which custom property are you looking for? The custom property on the alerts property page, or the alert trigger condition?

For the alert properties there seems like an easy way to query that out (FROM Orion.AlertConfigurationsCustomProperties)

For the alert trigger condition, not seeing an obvious answer but you can export the alerts (which also make a great backup), Export Orion Alerts.

monitoringlife

Looks like there is a reply from aLTeReGo on this post, "Quick way to look through all alert trigger definitions for a specific custom property?".

select * from AlertDefinitionsView WHERE TriggerQuery LIKE '%CustomPropertyName%'