Explanation of the Time Columns in nas_transaction_summary

Document ID : KB000012004
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

In the nas_transaction_summary table there are several columns that contain time information. 

What do they represent?

Answer:

There are four columns in the table nas_transaction_summary dealing with time.  All of these are times from the local nas probe, not the originating probe.  Here is a short description of each:

nimts
This is the timestamp recorded for the first alarm in this transaction. This column could have null values

created
This records the creation time of the transaction and should carry the same value as in the nimts

closed
This records the closure time of the transaction, null if this transaction has not been closed.

time
This records the timestamp of the latest actions(new alarms,update,close,acknowledged,assigned) in this transaction. For a closed transaction the value of time equals to the value of closed, so for a new transaction this should be the same as the value of created.

Additional Information:


The nas_transaction_log table also includes time columns, but these track different nas transactions and have only one transaction per line.