Is there a query that will list alarm policies with regex filters for a given group?
UIM with MS SQL Server database type
Use query below to list alarm policies with Regex filter. Example below list policies/conditions for CentOS7_9 group.
select Policy.name as "Policy Name",
PolicyMetric.name as "Policy Metric Name",
PolicyTarget.name AS "Group Name",
PolicyThreshold.type as "Alarm Type",
FROM Policy INNER JOIN
PolicyCondition ON Policy.id = PolicyCondition.policy_id INNER JOIN
PolicyMetric ON PolicyCondition.policyMetric_id = PolicyMetric.id INNER JOIN
PolicyTarget ON PolicyCondition.policyTarget_id = PolicyTarget.id INNER JOIN
PolicyThreshold ON PolicyCondition.id = PolicyThreshold.condition_id
WHERE PolicyTarget.name like 'CentOS7_9'
AND PolicyMetric.ciname like '~%'