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. 

Attachments:
ms_sql_event.jpg