When the Omni allows (grants) access via a HAI reader, it records the user and stores that in the log. I was my hope that the 'Logging to MySql' feature would carry this data into the log so I could setup some analysis but it seems not.
As a side note the create user is in error because it tried to create a user hai@10.1.1.15 which was the agent IP instead of using the server IP. This was easily corrected from the command line but its worth fixing if possible ( and optionally ask for a mask such as 10.1.1.% when creating ).
Anyway, back to the original query, can we get the USER who authenticated at the Lock into the database please?
If your really enthusiastic then adding an event OMNI User Unlocked Door (by User) then... would be even more helpful.
Thanks again for your hard work on this and have a great weekend!
As a side note the create user is in error because it tried to create a user hai@10.1.1.15 which was the agent IP instead of using the server IP. This was easily corrected from the command line but its worth fixing if possible ( and optionally ask for a mask such as 10.1.1.% when creating ).
Anyway, back to the original query, can we get the USER who authenticated at the Lock into the database please?
If your really enthusiastic then adding an event OMNI User Unlocked Door (by User) then... would be even more helpful.
Thanks again for your hard work on this and have a great weekend!