Powershell: AD Group Membership from OU: Difference between revisions
From Rabbi Blog
mNo edit summary |
m →Code |
||
| Line 3: | Line 3: | ||
=Code= | =Code= | ||
< | <SyntaxHighlight lang="powershell" line> | ||
################################################## | ################################################## | ||
## List Groups from Users found in target $OU ## | ## List Groups from Users found in target $OU ## | ||
| Line 38: | Line 38: | ||
# Export to $csvFilename | # Export to $csvFilename | ||
$users | Export-CSV $csvFileName | $users | Export-CSV $csvFileName | ||
</ | </SyntaxHighlight> | ||
[[Category:Powershell]] | [[Category:Powershell]] | ||
[[Category:Weblog-2019-04]] | [[Category:Weblog-2019-04]] | ||
Latest revision as of 10:12, 18 August 2026
Purpose
Using Powershell, Build a CSV of group membership from a designated OU.
Code
##################################################
## List Groups from Users found in target $OU ##
## V 0.1
##################################################
## To Do
## - Build Output to CSV [Done]
## - Build CLI variable for OU
###################################################
## Variables (System - Do Not Touch)
$DATE = (Get-Date -UFormat "%Y%m%d-%H%M%S-")
###################################################
## Variables (User)
$DOMAIN = "DC=rabbibob,DC=com"
$OU = "OU=Users"
$csvFileName = "AD_Groups_OUScan_$DATE$OU.csv"
####################################################
## Do Not Edit Below This Line
####################################################
$USERS = @()
$SEARCH_OU = "$OU,$DOMAIN"
write-host $SEARCH_OU
####################################################
# Start Search and array population
####################################################
$GetOU = Get-ADUser -SearchBase $SEARCH_OU -Filter *
$USERS = foreach ($user in $GetOU) {
$UserDN = $user.DistinguishedName
$Name=$user.SamAccountName
Write-Host "Processing" $Name
Get-ADGroup -LDAPFilter "(member=$UserDN)" | Select-Object @{Name='User';Expression={$Name}},GroupCategory,GroupScope,Name,ObjectClass,SamAccountName
}
####################################################
# Export to $csvFilename
$users | Export-CSV $csvFileName