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

Question

Question

How to query User with organization in LFDS Database ?

How To Directory Server
Updated May 11, 2021
asked on May 10, 2021 • Show version history

From LFDS database :

How do I find which organization a user belong , in [directory_objects] I can find the user (type =0) and the organization (type =3) but I don't find which table join the user sid and the organization sid like the group with [group_membership].

Any idea ?

0 0

Answer

SELECTED ANSWER
replied on May 11, 2021

Thanks Stephen, 

 

Found it : The [directory_objects].[container_id] of the user (type =0) point on the  [directory_objects].[id] of the organization.

0 0

Replies

replied on May 11, 2021

I'm not 100% sure if this is correct, but I believe that organizations use the namespace_id from the directory_objects table and the namespaces table.

If this is the case then you can try joining the effective_namespace_id of the user with the namespace name.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...