Need a report on all the alarm policies in UIM

Products

• Support Offerings

Issue/Introduction

We need a report to pull the information on the alarm policies and all the threshold values.

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - ALARM POLICY

Resolution

Currently (As of this writing, July 2021) there is no method or built-in report for all alarm policies; this would be considered an enhancement request.

It is possible to individually export alarm policies into JSON/XML format using the API, and this could be leveraged for some customized reporting but this would be outside the scope of support.  The intention of this is to export policies from a pre-production environment and import them to production, so other uses would be considered unsupported (but it might be possible to do.)

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/configuring-and-viewing-monitoring-data/manage-alarms-with-centralized-alarm-policies.html#concept.dita_f16e8c44518bae1bd89925d2bc51fa0a323a025d_ExportImportAlarmPolicies

The following SQL query might also be a good starting point - this is unsupported and provided *AS-IS* as an example only:

select PolicyMetric.name as "Policy Name", PolicyMetric.probeName as "Probe",  PolicyMetric.qos, 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

 

Otherwise there is no single report for this.

Additional Information

Note: this query does not account for time-over-threshold/time-to-threshold alarms, only static alarms will be properly displayed.   The query will likely need some modification if you need more details about non-static alarms.