MKP_MSI

NAS_TRANSACTION_LOG fields

Discussion created by MKP_MSI on Sep 13, 2011
Latest reply on Sep 14, 2011 by bvloch1

Can someone tell me if the following define the record types in the NAS_TRANSACTION_LOG table. And if each type is defined as such, does the metric captured in NIMTS or TIME fields in this table define something different based on the record type? We are seeing differing variables in these 2 fields based on record type for the same NIMID. We need to understand exactly what each field represents (NIMTS and TIME) for each record type.

 

NAS_ALARM_NEW= 1

NAS_ALARM_UPDATE= 2

NAS_ALARM_CLOSE= 4

NAS_ALARM_ASSIGN= 8

NAS_ALARM_ACK= 32

 

End goal is to extract out from this table the time from alert start to time the alert was assigned to a specific person. Documentation on this probe and it's corresponding tables are poor and the following sites did not give definitive explanations of the difference.

 

http://forum.nimsoft.com/nimsoft/attachments/nimsoft/13/1091/1/nas.pdf

 

There is no indication in this doc as to why we are seeing different date/times in these fields with different record types for same NIMID. Is this a problem with the tool?

Outcomes