Is there a query that will list alarm policies with regex filters for a given group?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Is there a query that will list alarm policies with regex filters for a given group?

Environment

UIM with MS SQL Server database type

Resolution

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",
PolicyMetric.probeName,
PolicyMetric.qos,
PolicyMetric.ciname,
PolicyTarget.name AS "Group Name",
PolicyThreshold.type as "Alarm Type",
PolicyThreshold.operator,
PolicyThreshold.value,
PolicyThreshold.severity
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 '~%'