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

Discussion

Discussion

Last sign-in time in LFDS 12, database location?

Directory Server Version 12 Administration
Updated November 14
posted on November 13

I just updated my LFDS server to 12, and I really like the new column for last sign-in time. What I really want to do is a multiple-group filter to see last sign-in times for users in a handful of similar groups. I can't find that feature in the UI, so my next thought is I could probably do this with a SQL query. I can't find where the last sign-in data point lives. Can any help with that? 
Thank you

0 0
replied on November 14

Here is what I use

select u.username,s.last_active 
from [LF_Forms].[dbo].[cf_users]
AS u inner join  [LF_Forms].[dbo].[cf_sessions] 
AS s on s.user_id=u.user_id
WHERE u.username != '_anonymous'

 

0 0
replied on November 13

dbo.user_logins table

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

Sign in to reply to this post.

Details
Related Posts
Loading ...