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

Solution

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

Was this article helpful? yes / no

Article details

Article ID:	142
Category:	AMS Software
Views:	959
Rating (Votes):	(0)

« Go back

$s = 1; if (file_exists(HESK_PATH . 'hesk_license.php')) { $h = (!empty($_SERVER['HTTP_HOST'])) ? $_SERVER['HTTP_HOST'] : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME')); $h = str_replace('www.','',strtolower($h)); include(HESK_PATH . 'hesk_license.php'); if (isset($hesk_settings['license']) && strpos($hesk_settings['license'],sha1($h.'h3&Fp2#LaA&59!w(8.Zc]*+uR512')) !== false) { $s = 0; } else { echo '

INVALID LICENSE (NOT REGISTERED FOR '.$h.')!

'; } } if ($s) { echo '

'; } echo '