How can one export a list of all the groups and respective users in LF directory server?

SELECTED ANSWER

replied on January 5, 2023

If you use the on-prem version and are comfortable with SQL, here's the query for a view I created for this. The data is in a table named group_membership but that only shows the sid (which is a giant, scary number), so link it to the account in directory_objects

SELECT        dbo.directory_objects.name AS GroupName, directory_objects_1.name AS UserName
FROM            dbo.group_membership LEFT OUTER JOIN
                         dbo.directory_objects AS directory_objects_1 ON dbo.group_membership.member_sid = directory_objects_1.sid LEFT OUTER JOIN
                         dbo.directory_objects ON dbo.group_membership.group_sid = dbo.directory_objects.sid

2 0

View 1 previous reply

replied on January 9, 2023

Thank you, Pieter for sharing your code! Very appreciated.

I passed your message along to the person in our institutions that has access to the server and can run the script there. Unfortunately, I can't do it myself.

Best,

Patricia.

0 0

replied on February 16, 2023

Thank you very much for this - you saved me a lot of time!!

1 0

replied on July 5, 2023

Where are the group_membership and directory_objects dbos located. I looked in the Repository Database but did not see them. I'm on LF version 10.4 (10.4.0.311).

0 0

replied on July 14, 2023

Hi Jerry-

This is in the LFDS database.

0 0

Question

Question

How can one export a list of all the groups and respective users in LF directory server?

Answer

Replies

Sign in to reply to this post.