Question

How to have the list of Windows Accounts in the SQL database

Updated May 17, 2016

asked on May 17, 2016

Hy,

i want to make a SQL request in the SQL DB to get all the Windows Accounts but I don't know how. In the table trustee, there are the LF Users and Groups but not the Windows Accounts.

I also want to know to which groups they belong. In which table can I find this?

Thanks for your help

0 0

Replies

replied on May 17, 2016

Hi Frederic,

Can't help with the windows accounts but by the looks of things if I was to hazard a guess, dbo.grouplist looks pretty close for the group memberships. Bear in mind this won't include AD group membership.

0 0

replied on May 17, 2016

Hi Chris,

I have seen that in the table group_list, you have only the LF groups and accounts.

In my case, I have LF groups that contains AD users and I'd like to have the list of AD users with the LF groups they belong to. So the table group_list is not useful here.

0 0

replied on May 17, 2016

Can you explain what the end goal is? Laserfiche does not keep a list of Windows accounts by name, just SIDs.

0 0

replied on May 17, 2016

Hi Miruna,

the goal of this is to have statistics about the search with Weblink. There are two types of data in our repository and users have the rights only on one kind of data. These rights depend on the groups they belong to.

So if we know to which group a user belongs to, we know which kind of data he has searched on.

In the table audit_event, there are the columns trustee and event_trustee_sid. So we have the sid of the user. Is there a way to know to which LF group this SID belongs ?

0 0

You are not allowed to follow up in this post.

Question

Question

How to have the list of Windows Accounts in the SQL database

Replies

Sign in to reply to this post.