AnsweredAssumed Answered

NAS_TRANSACTION_LOG "type" definitions

Question asked by owngeek on Apr 5, 2011
Latest reply on Apr 5, 2011 by carstein.seeberg

Team,

 

I am trying to write a perl program to pull out the NAS ALARM data form the sqlite file "transactionlog.db".

 

I need to figure out what are all the possible definition types in the field value.  So far I have ascertained the following:

NAS_TRANSACTION_LOG Filed "type"

 

"open" "type" = 1
"close" "type" = 4
"assigned" "type" = 8
"acknowledged" "type" = 32

 

 

Anyone know what is the number 2, and 16 are?

 

I need to get the values of the following:

1. When an alarm was assigned

2. When an alarm was accepted

3. When an alarm was acknowledged

4. Who assigned the alarm

5. Who accepted the alarm

6. Who acknowledged the alarm

 

I assume when assigned_to = assigned_by the time that happens is what makes up "accepted_at"

Outcomes