How to do processing in 1s8? Detailed in the details of the question?

Question

1C

Tell me, please, how to make it so that 1s displays information about the arrival and departure of the employee and the place of movement in the office. as I understand it, it is necessary that 1s take the ID and the passage time from the base. and they want it for 1s
From the MSSQL database to see who came what time, every time I make the following query:
SELECT TOP (200) TimeVal, Remark, DeviceTime
FROM pLogData
WHERE (HozOrgan = 400)
ORDER BY TimeVal DESC

Answer 1

Here is the theory needed for writing processing on your own - infostart.ru/public/92746
Here is the already written processing of connecting to an external DBMS - infostart.ru/public/137872