This is sort of a how to make the sausage type question.

I do weekly, monthly and yearly reports of total logins to Pyramid and unique user logins. I do this by exporting the Entries log for the time period I want to report on then remove failed logins and logouts.

As I was starting to work on the numbers for all of 2023 it occurred to me that rather than doing all of this manually that it would be great to have a data model that I could report against since I was pretty sure that all of the Pyramid log data was stored in the Pyramid repository database. 

I believe the entry log data is stored in the dbo.server_logs_audit table. 

Most of the column names make sense, typed_user_name, authentication_method_invoked, time, type, client_ip, user_id, tenant_id, source, entry_source, custom_data

What I do have questions about are time, type, source, and entry_source.

Type, source, and entry_source are integers but I think I can figure out what the integers correspond to in the Entries Log. 

The one I have the biggest question about is time. The column type is BigInteger and  values appear to all be 13 digits (for example: 1698951758850) and I cannot figure out how that gets translated to a date. 

Can someone from Pyramid confirm that I have the right table and provide some info on how they are translating the 13 digit number into a date and time?

Thank you!