The AUDITLOGONS table keeps a record of each LOG ON and LOG OFF for each user, along with the application (Lucity Desktop, Lucity Web, Security, Admin Tools, GIS, etc). You may try adding that table and see if it gives you the data you're looking for. I haven't developed any reports myself, but have run some ad-hoc queries.
Active User Reporting
I am trying to create an Active User Report to show how often users are logging in and what applications they are accessing over time.
In Crystal Reports, I have connected to the ACTIVEUSER table. It looks like this table only stores the last time a user accessed a specific module, but there isn't a great way to determine how frequently they log on (daily, weekly, etc). Is there another table in the Lucity database that stores this type of information?
Has anyone else developed a way to track this information? I would like to use it to present to our Board.
Please sign in to leave a comment.
Thanks for the tip Tom. I'll check it out.
One thing I noticed, now that I'm clicking thru here, is the AUDITLOGONS table does not seem to capture users logging into the mobile (iOS) application. The ACTIVEUSER table will show the Lucity Mobile REST app activations, but they don't appear in AUDITLOGONS.
It looks like with a bit of formula work I should be able to use these two tables to organize the information I was looking for.
Thanks for the tip Tom.