DX Infrastructure Manager

Expand all | Collapse all

What are all the date fields

Jump to Best Answer
  • 1.  What are all the date fields

    Posted 04-16-2018 12:12 PM

    Does anyone have a definition of all the date fields in the UIM database (nas_transaction_summary & nas_transaction_log)? And how do they match up to the fields in the UI - both Infrastructure Manager and USM. 

     

    nas_transaction_log

    [time]

    [nimts]

     

    nas_transaction_summary

    [created]

    [closed]

    [time]

    [nimts]

     

    IM - Alarm Details

    [Time Received]

    [Time Origin]

    [Time Arrival]

     

    IM - Alarm History

    [Time Created]

    [Time]

     

    IM - Transaction History

    [Time]

     



  • 2.  Re: What are all the date fields

    Posted 04-17-2018 05:51 AM

    Hi Steve,

    Below is what each value corresponds to:

     

     

    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 "created" field of the NAS_TRANSACTION_SUMMARY.
    [nimts] in the transaction_log the nimts is static and corresponds to "created" field of the NAS_TRANSACTION_SUMMARY.

    nas_transaction_summary
    [created] This is the date and time of the first occurrence of the alarm.
    [closed] This is only filled when the alarm is acknowledged and corresponds to the time when the alarm is aknowledged.
    [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 "created")

    IM - Alarm 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 "time_origin" of the NAS_ALARMS and the "created" field in the nas_transaction_summary.
    [Time] Corresponds to the "time" field in the nas_transaction_summary (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)

    IM - Transaction History
    [Time] corresponds to the "time" of the transaction_log



  • 3.  Re: What are all the date fields

    Posted 04-17-2018 09:38 AM

    Marco_Ippati - Thank you! One question on the [nimts] & [created] fields: I have a fair amount of records where this is different (although the vast majority are the same). Is this because the [nimts] field is when the alarm message was generated on the robot, and the [created] field is when it was actually created as an alarm in nas? 



  • 4.  Re: What are all the date fields
    Best Answer

    Posted 04-18-2018 06:14 AM

    Hi Steve,

     

    In those cases where [nimts] and [created] are not the same, what happens is the following: The [nimts] will always match the [time].nas_transaction_log of the first instance and the time_origin.nas_alarms. The  [created] instead can be updated after in the life of the alarm; for example if the alarm is cleared but not acknowledged (see all updated descriptions below!)

     

    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, 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.



  • 5.  Re: What are all the date fields

    Posted 04-18-2018 10:57 AM

    Thanks Marco!