Actions

Powershell: AD Group Membership from OU: Difference between revisions

From Rabbi Blog

mNo edit summary
 
Line 3: Line 3:


=Code=
=Code=
<pre>
<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
</pre>
</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