How many alarms were generated for each probe.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Could you provide the query to determine how many alarms were generated for each probe?

Environment

UIM 23.4.46

NAS 23.4.4.1

Resolution

Run the query below to determine the number of alarms generated for each probe in transaction.db.

SELECT
    robot,
    prid,
    COUNT(*) AS alarm_count
FROM NAS_TRANSACTION_LOG
GROUP BY
    robot,
    prid