What do the time related fields mean in the Alarm Tables in UIM?

Document ID : KB000091867
Last Modified Date : 18/04/2018
Show Technical Document Details
Question:
What do the "TIME" fields mean in the alarm tables?
What do the TIME fields correspond to in the NAS_ALARMS the NAS_TRANSACTION_SUMMARY and the NAS_TRANSACTION_LOG tables?
Environment:
uim 8.x
Answer:

NAS_ALARMS

[time_origin] corresponds to the date and time when the alarm was originated
[time_arrival] corresponds to the date and time when the alarm arrived to the nas
[nimts] corresponds to the epoch format of the [time_origin].nas_alarms

NAS_TRANSACTION_LOG

[time] This value corresponds to the date and time each instance of the alarm was originated. In the first occurrence of the alarm this field correspond to the [time_origin].nas_alarms
[nimts] corresponds to time_origin.nas_alarms

 

NAS_TRANSACTION_SUMMARY
[created] Normally the created field corresponds to the date and time of the first occurrence of the alarm (so it corresponds to the [time_origin].nas_alarms and [time].transaction_log of the first occurrence of the alarm)*
*If the NAS is configured to NOT "Accept automatic 'acknowledgement' of alarm, (Nas setup key: "allow_close_on_suppkey = no") the Created field might not correspond to the [time_origin].nas_alarms. When "Accept automatic 'acknowledgement' is not active, the level 0 alarms (Clear alarms) do not close the alarm. When the "Accept automatic 'acknowledgement' option is ticked (it is by Default when a clear alarm arrives it automatically acknowledges the alarm. Any new occurrence after being cleared and acknowledge will be a new alarm (new nimd). 
When the "Accept automatic 'aknowledgement' option is NOT ticked, a clear alarm is treated as a normal alarm: it will have the same nimid. In this case when a clear alarm comes in it doesn't close the alarm and it resets a the [created].nas_transaction_log. In this cases the [created].nas_transaction_log does not correspond to the time_origin].nas_alarms but it would match instead the [time].transaction_log of the first occurence right after the clear alarm. 
[closed] This is only filled when the alarm is acknowledged and corresponds to the time when the alarm is acknowledge.
[time] This corresponds to the date and time of the last occurrence of the alarm (And it is the same value as the [time] field of the last occurrence of the transaction_log)
[nimts] This is the date and time of the first occurrence of the alarm. (same as [time_origin].nas_alarms)

 

IM - ALARMS DETAILS
[Time Received] Corresponds to the "time" field in the nas_transaction_summary 
[Time Origin] Corresponds to the "time_origin" of the NAS_ALARMS and "created" field in the nas_transaction_summary.
[Time Arrival] Corresponds to the "time_arrival" field of the NAS_ALARMS (which is the time stamp of when the alarms was actually received by the nas)

 

IM - ALARM HISTORY
[Time Created] Corresponds to the [created] .nas_transaction_summary. 
[Time] Corresponds to the [time] .nas_transaction_summary.

Additional Information:
Related Articles:

Where are the alarms stored in UIM?

What do the time related fields mean in the Alarm Tables in UIM?

nas Transaction Logging/Transaction Summary and compression

What is the meaning of the of nas alarm Subjects?

Why do some alarms' "count" increase immediately in the alarm console while others don't show the count increasing even when the alarms are suppressed?

Nas alarm counts are not in sync between UMP USM and the Infrastructure Manager alarm subconsole

Documentation: Nas (alarm server) 

Documentation: Nas Message Suppression Tab