Jakinid Support Website > Help Desk ( > Knowledgebase

Search help:

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. 

ms_sql_event.jpg ms_sql_event.jpg

Was this article helpful? yes / no
Related articles When I viewed the Event Logs,why there is a ID-Unknown event displayed?
How to resend the registered device's event logs data back to the AMS SaaS domain database?
After the device was registered with AMS,I did not see any Event Logs sending to AMS.What can I do?
What are the steps for the migration from the on-premises AMS to the AMS SaaS?
What were Event Logs "Case Is Opened" and "Case is Closed" about?
Article details
Article ID: 142
Category: AMS Software
Views: 1025
Rating (Votes): Article not rated yet (0)

« Go back

Powered by Help Desk Software HESK, in partnership with SysAid Technologies