Export all members under the security tab for all security groups

%3CLINGO-SUB%20id%3D%22lingo-sub-2626194%22%20slang%3D%22en-US%22%3EExport%20all%20members%20under%20the%20security%20tab%20for%20all%20security%20groups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2626194%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHi%20all%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3ENot%20sure%20if%20this%20is%20possible%20but%20i%20need%20the%20following%3A%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20been%20tasked%20with%20running%20a%20report%20to%20export%20all%20users%20listed%20in%20the%20security%20tab%20and%20their%20permissions%20into%20an%20Excel%20spreadsheet%20so%20we%20can%20see%20who%20is%20missing%20from%20being%20able%20to%20manage%2Fadd%2Fremove%20users%20to%20those%20security%20groups.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20want%20to%20be%20able%20to%20run%20this%20against%20all%20security%20groups%20in%20AD.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EIn%20the%20export%20i%20want%20the%20first%20column%20to%20have%20the%20name%20of%20the%20security%20group%2C%20second%20column%20the%20name%20of%20the%20user%20and%20third%20column%2C%20the%20permissions%20they%20have.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20don't%20want%20the%20members%20of%20that%20group%2C%20i%20want%20the%20users%20listed%20in%20the%20SECURITY%20tab.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3ECREATOR%20OWNER%3CBR%20%2F%3ESELF%3CBR%20%2F%3EAuthenticated%20Users%3CBR%20%2F%3Eetc.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2626194%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EWindows%20PowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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