Export all members under the security tab for all security groups

Copper Contributor

Hi all,

 

Not sure if this is possible but i need the following:

 

I have been tasked with running a report to export all users listed in the security tab and their permissions into an Excel spreadsheet so we can see who is missing from being able to manage/add/remove users to those security groups.

 

I want to be able to run this against all security groups in AD.

 

In the export i want the first column to have the name of the security group, second column the name of the user and third column, the permissions they have.

 

I don't want the members of that group, i want the users listed in the SECURITY tab.

 

CREATOR OWNER
SELF
Authenticated Users
etc.

 

Thank you

1 Reply