I'm creating Power BI dashboards for statistics/analytics for our director. I can give a good count of forms users and the last time they logged into forms, but I am having trouble finding the same information for the repository. Any help or hints would be greatly appreciated.
Question
Question
Answer
That one does exist in the repository database.
SELECT [last_login]
,[account_name]
FROM [user_login] ul INNER JOIN [account_cache] ac
ON ul.[sid] = ac.[account_sid]
WHERE ul.[last_login] IS NOT NULL
Replies
What kind of tracking are we talking about? The repository does not keep historical data in the database. It's only available in Audit Trail. Some info on how to get data out of Audit Trail in a reportable format can be found here.
Mainly, I just want last login time. For users, we are just looking for them being active - I know Laserfiche has that information, but I'd like to put it all in one place - PowerBI...
That one does exist in the repository database.
SELECT [last_login]
,[account_name]
FROM [user_login] ul INNER JOIN [account_cache] ac
ON ul.[sid] = ac.[account_sid]
WHERE ul.[last_login] IS NOT NULL
You're awesome! That is exactly what I'm looking for! Thank you so much.
One more thing... Is there a field somewhere to say what license the user has, or if they are active/deactive?
Oh, and probably worth stating for other readers. The SQL query above only gives you users who have used the repository. If they're only using Forms, they won't show in the list and you'd need to query LFDS instead (or the Forms DB in setups that do not use LFDS).