You are viewing limited content. For full access, please sign in.

Question

Question

Anyone write a PowerBI to track users?

asked on November 3

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.

0 0

Answer

SELECTED ANSWER
replied on November 3

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

 

1 0

Replies

replied on November 3

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.

0 0
replied on November 3

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...

0 0
SELECTED ANSWER
replied on November 3

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

 

1 0
replied on November 3

You're awesome!  That is exactly what I'm looking for!  Thank you so much.

0 0
replied on November 3

One more thing...  Is there a field somewhere to say what license the user has, or if they are active/deactive?

0 0
replied on November 3

That's in LFDS these days. Bert's post in this thread might help.

0 0
replied on November 3

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). 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.