Last occurrence date is not updated on alarms in UIM 20.4 CU2 OC

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The "last occurrence" date in the OC alarm view is not getting updated correctly.

 

Environment

Release : 20.4

Component :

Cause

Working as designed

Resolution

IM and alarm console (OC) retrieve data from different sources. The settings nis_update_skip_factor & supp_divisor on NAS configuration will help the OC alarm console to show the same values as IM GUI but these are applicable for only new incoming alarms and it doesn't update existing alarms.

 

To update existing alarms, we provided the script for one-time updates. 

Please be aware this is a one-time update, new alarms will still show the Last Occurrence of the last event change: 

Read More: UIM 20.4 - "Last Occurrence" and "Event Count" Explained (broadcom.com)

 

The script below will update the data in NAS_TRANSACTION_SUMMARY.

NOTE: We would recommend to backup the tables NAS_ALARMS, NAS_TRANSACTION_SUMMARY, and NAS_TRANSACTION_LOG before running the script. 

Connect to any data client and run the below statements. Run MSSQL scripts for the MSSQL database, run MYSQL scripts for the MYSQL database. 

 

MSSQL Script 
================================

UPDATE NTS
SET NTS.TIME = NTL.TIME
FROM 
NAS_TRANSACTION_SUMMARY NTS join
(
    select NIMID, MAX(TIME)    AS TIME
    from NAS_TRANSACTION_LOG
    group by NIMID
) NTL
on NTS.NIMID = NTL.NIMID
================================

 

MYSQL Script

================================

SET SQL_SAFE_UPDATES=0;

 

Update NAS_TRANSACTION_SUMMARY NTS join
(
    select NIMID, MAX(TIME)    AS TIME
    from NAS_TRANSACTION_LOG
    group by NIMID
) NTL
on NTS.NIMID = NTL.NIMID
set NTS.TIME = NTL.TIME;

 

SET SQL_SAFE_UPDATES=1;

================================

 

 

Additional Information

- What are the 3 date/time fields in the OC alarm view explanation?
    Creation Date & Time - Normally the created field corresponds to the date and time of the first occurrence of the alarm
    Arrival Time - corresponds to the date and time when the alarm arrived in the NAS
    Last Occurrence - This corresponds to the date and time of the last event change of the alarm

Read more: UIM - Time related fields in the NAS_* alarm Tables (broadcom.com)

  
- What has this script to do with the online console?
  The one-time script updates the time column in NAS_TRANSACTION_SUMMARY table which is displayed as the last occurrence date in UI.