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

Question

Question

Can you see last login for LFDS users

asked on May 2, 2017

Hello all,

I'm trying to see if there is a way to see when the last time an account in LFDS logged into the repository. I can see LF accounts last login in the Admin Console but I don't see the same information in LFDS. Any ideas? 

My task is seeing if people that are giving full license actually need them or if they can be converted to forms participants. If anyone has an idea of the best way to attack that problem let me know. Thanks for the help. 

0 0

Replies

replied on May 3, 2017

If you only want to check the last active time for the user that log in Forms, you can run following query on the Forms database:


 select u.username,s.last_active from [dbo].[cf_users]AS u inner join  [dbo].[cf_sessions] AS s on s.user_id=u.user_id

 

0 0
replied on May 3, 2017

In the desktop administration console (and I'd imagine also in the other repository administration offerings) there are columns for Last Login and Last Logout in the user lists.

You could also run an audit report for login events, if that is being recorded.

0 0
replied on April 25, 2019

Hello,

can we request this information to be available in a future version of LFDS?

I mean, to be able to see directly in LFDS console the last login of users, as it is available in the LF Administration Console.

 

In many cases this is a useful information and it is not practical to run the SQL queries or Audit Trail reports for it.

 

Thanks and regards,

 

Ignacio PdeA

BMB sal

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

Sign in to reply to this post.