We had some questions about the AMS DB.Inside AMS Event Logs table,there are 3 timestamps,can you explain what did they mean?

Please kindly check the below information,and the attached file as an example.

 

  • TIMESTAMPS : the standard time UTC of event logs received from the reader/terminal
  • LOCAL_TIMESTAMP: the converted local time of event logs received from the reader/terminal
  • RECLOGDTM: the server timestamp when it received event logs from the reader/terminal

 

In summary,the Event Logs data sending from the registered devices to AMS database are "TIMESTAMPS " (UTC) .

After that,based on the time zone settings under AMS server setup webpage,the AMS will auto-convert the received "TIMESTAMPS " (UTC)  to "LOCAL_TIMESTAMP" (e.g.Singapore timezone setting is GMT+8 ) to be used for viewing Event Logs or generating AMS reports.