Hi, I would like to export in a csv file all groups and nested groups from bulk AD user or OU.Example:UsersGroupsNestedGroups User1Group1NestedGroup1NestedGroup2NestedGroup3 Group2NestedGroup1NestedGroup2 Group3NestedGroup1NestedGroup2NestedGroup3NestedGroup4NestedGroup5NestedGroup6NestedGroup7NestedGroup8NestedGroup9NestedGroup10 Group4NestedGroup1NestedGroup2NestedGroup3NestedGroup4 Group5NestedGroup1NestedGroup2NestedGroup3NestedGroup4NestedGroup5 User2Group1NestedGroup1NestedGroup2NestedGroup3 Group2NestedGroup1NestedGroup2 Group3NestedGroup1NestedGroup2NestedGroup3NestedGroup4NestedGroup5NestedGroup6NestedGroup7NestedGroup8NestedGroup9NestedGroup10 Group4NestedGroup1NestedGroup2NestedGroup3NestedGroup4 Group5NestedGroup1NestedGroup2NestedGroup3NestedGroup4NestedGroup5 Thanks

Hi Alan, thanks for the powershell provided.Is it possible to export the results as requested please ?

Diego13 Hi, Yes you can just save them in a variable like $result. Then use export to csv ps script.$result | Export-Csv c:\temp\test.csv -NoTypeInformation

Hi,I have this error now when adding "$result | Export-Csv c:\temp\test.csv -NoTypeInformation" at the end of the script:Get-ADGroupMember : Cannot find an object with identity: 'GroupName' under: 'DC=...'

Complete error:Get-ADGroupMember : Cannot find an object with identity: 'GroupName' under: 'DC=...,DC=...'.At line:6 char:1+ Get-ADGroupMember -Identity 'GroupName' -Recursive | Select-Object -P ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : ObjectNotFound: (GroupName:ADGroup) [Get-ADGroupMember], ADIdentityNotFoundException+ FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADIdentityNotFoundException,Microsoft.ActiveDirectory.Management.Commands.GetADGroupMemberGet-ADGroup : Cannot validate argument on parameter 'Identity'. The argument is null. Provide a valid value for the argument, and then try running the command again.At line:7 char:23+ Get-ADGroup -identity $item.GroupName | select name | Export-csv -pat ...+ ~~~~~~~~~~~~~~~+ CategoryInfo : InvalidData: (:) [Get-ADGroup], ParameterBindingValidationException+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.GetADGroup

Forum Discussion

Diego13

Copper Contributor

Nov 09, 2022

Get nested AD groups from bulk user or OU

Hi,

I would like to export in a csv file all groups and nested groups from bulk AD user or OU.

Example:

Users	Groups	NestedGroups
User1	Group1	NestedGroup1	NestedGroup2	NestedGroup3
	Group2	NestedGroup1	NestedGroup2
	Group3	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4	NestedGroup5	NestedGroup6	NestedGroup7	NestedGroup8	NestedGroup9	NestedGroup10
	Group4	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4
	Group5	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4	NestedGroup5
User2	Group1	NestedGroup1	NestedGroup2	NestedGroup3
	Group2	NestedGroup1	NestedGroup2
	Group3	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4	NestedGroup5	NestedGroup6	NestedGroup7	NestedGroup8	NestedGroup9	NestedGroup10
	Group4	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4
	Group5	NestedGroup1	NestedGroup2	NestedGroup3	NestedGroup4	NestedGroup5

Thanks

Iron Contributor

# Filter Groups in AD based on OU
$searchBase = "OU=Test,DC=company,DC=com"
Get-ADGroup -Filter * -SearchBase $searchBase -Property * | Sort-Object Name 

# Get List of Members base on Group Name
Get-ADGroupMember -Identity '<GroupName>' -Recursive | Select-Object -Property @{n="Members"; e={ $_.Name }} | Sort-Object Members

Diego13
Copper Contributor
Nov 10, 2022
Hi Alan, thanks for the powershell provided.
Is it possible to export the results as requested please ?
- Alan2022
  Iron Contributor
  Nov 11, 2022
  Diego13
  
  Hi,
  
  Yes you can just save them in a variable like $result. Then use export to csv ps script.
  
  $result | Export-Csv c:\temp\test.csv -NoTypeInformation

Forum Discussion

Get nested AD groups from bulk user or OU

Share

Resources