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

Question

Question

Repository Database Table that lists Windows Users

Laserfiche
Updated April 8, 2021
asked on April 8, 2021

Does anyone know which database table lists the Windows Users IDs with their associated Active Directory IDs? I understand it does not store the username but that is ok.

Similar to the table named trustee for Laserfiche Users.

The use case for this is to receive a notification if a user has not logged in for a long period of time.

0 0

Answer

SELECTED ANSWER
replied on April 8, 2021

If your use case relates to login history, the user_login table should have what you need.

The only columns are sid, last_login, and last_logout, and the sid column will match the binary sid value from Active Directory.

0 0
replied on April 8, 2021

Oh, I was thinking this sid was the internal Laserfiche ID for the user. Since Laserfiche Users who are not Windows Users have an sid which links to their account.

That will work thank you!

0 0
replied on April 8, 2021

It's both. Repository users have their IDs generated by Laserfiche, Laserfiche users get their SID generated by LFDS, Windows users use their domain SID.

2 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...