Powershell to get group, members and member of details

acgksxr · 2021-04-09T12:51:34.000Z

I’m trying to use powershell to get a list of global groups in an OU and output the global group name, the members of the group and the domain local groups the global group is a member of, so far I have the output below, but I get the output for the “member of” details

$OU = ‘OU=Role Groups,OU=USG,OU=Groups,OU=xxx,OU=xxxxxx,DC=xxxxxxx,DC=xxx’ $Groups = Get-ADGroup -Filter * -SearchBase $OU $Data = foreach ($Group in $Groups) { Get-ADGroupMember -Identity $Group -Recursive | Select-Object @{Name=‘Group’;Expression={$Group.Name}}, @{Name=‘Member’;Expression={$_.Name}} } $Data | Export-Csv -Path “C:\Temp\FolderPermissions.csv”

Thanks

Neally · 2021-04-09T13:25:42.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2021-04-09T13:32:14.000Z

try like so

$OU = 'OU=Role Groups,OU=USG,OU=Groups,OU=xxx,OU=xxxxxx,DC=xxxxxxx,DC=xxx' 

$Groups = Get-ADGroup -Filter * -SearchBase $OU 

$Data = 
foreach ($Group in $Groups) { 
    Get-ADGroupMember -Identity $Group -Recursive |
    Select-Object @{Name='Group';Expression={$Group.Name}}, @{Name='Member';Expression={$_}}
}

$Data | 
Export-Csv -Path "C:\Temp\FolderPermissions.csv"

acgksxr · 2021-04-09T13:49:46.000Z

$OU = 'OU=Role Groups,OU=USG,OU=Groups,OU=xxx,OU=xxxxxx,DC=xxxxxxx,DC=xxx'

$Groups = Get-ADGroup -Filter * -SearchBase $OU

$Data = foreach ($Group in $Groups) {

 Get-ADGroupMember -Identity $Group -Recursive | Select-Object @{Name='Group';Expression={$Group.Name}}, @{Name='Member';Expression={$_.Name}}

 $Data | Export-Csv -Path "C:\Temp\FolderPermissions.csv"

jitensh · 2021-04-09T13:53:42.000Z

I think you want to see group scope global, local or univrersal

$OU = 'OU=Role Groups,OU=USG,OU=Groups,OU=xxx,OU=xxxxxx,DC=xxxxxxx,DC=xxx' 

$Groups = Get-ADGroup -Filter * -SearchBase 'OU=Role Groups,OU=USG,OU=Groups,OU=xxx,OU=xxxxxx,DC=xxxxxxx,DC=xxx' 

$Data = foreach ($Group in $Groups) { 
    Get-ADGroupMember -Identity $Group -Recursive |
    Select-Object @{Name='Group';Expression={$Group.Name}}, @{Name='Member';Expression={$_.name}},@{Name='GroupScope';Expression={$Group.GroupScope}}
}

$Data | 
Export-Csv -Path "C:\Temp\FolderPermissions.csv"

acgksxr · 2021-04-09T14:18:31.000Z

Hi

I would like the be able to run the script against the Global OU and get the names of the groups the users in the group and the domain local groups that the global group is a member of. like the output below, at present I can get the Global and user columns but I can get the member of column populated with the domain local groups.

Capture111.jpg549×504 79.4 KB

acgksxr · 2021-04-16T07:12:18.000Z

Any Ideas on how to pull the following information;

Group

Group Members

Groups this group is a member of.

Thanks