ACS SPHINX MySql, where is the input/output table?

Question

MySQL

There is an ACS SPHINX, connected to the database on MySql, but nowhere is there a table with a log of inputs and outputs. Maybe someone figured out, unsubscribe pliz?

Answer 1

they have 2 bases, one is for storing system settings, the second is for information
An example of how to collect only pass events:
> select id,logtime,devhint,emphint,ord(substr(logdata,5,1)) as dir from logs where substr(logdata ,1,2)=0xFE06;
Output columns:
id - unique integer event identifier
logtime - event time
devhint - access point (door ID, =DEVICES.ID)
emphint - employee ID (=PERSONAL.ID)
dir - direction. 1=out, 2=in