Skip to content

Instantly share code, notes, and snippets.

@raulunzue
Last active December 12, 2020 10:09
Show Gist options
  • Save raulunzue/e7c0ae30db9b4f82997606dc5b354e0d to your computer and use it in GitHub Desktop.
Save raulunzue/e7c0ae30db9b4f82997606dc5b354e0d to your computer and use it in GitHub Desktop.
Powershell para extraer todos los usuarios de directorio activo de ciertos grupos a CSV
###################
### RAUL UNZUE - ELBLOGDENEGU
### SCRIPT POWERSHELL
## EXTRAER USUARIOS GRUPOS AD
###################
$groups = (Get-AdGroup -SearchBase "OU=IMPRESORAS,DC=NEGU,DC=LOCAL" -filter * | Where {$_.name -like "**"} | select name -expandproperty name)
$Table = @()
$Record = @{
"Group Name" = ""
"Name" = ""
"Username" = ""
}
Foreach ($Group in $Groups) {
$Arrayofmembers = Get-ADGroupMember -identity $Group -recursive | select name,samaccountname
foreach ($Member in $Arrayofmembers) {
$Record."Group Name" = $Group
$Record."Name" = $Member.name
$Record."UserName" = $Member.samaccountname
$objRecord = New-Object PSObject -property $Record
$Table += $objrecord
}
} $Table | export-csv "C:\Users\raul\Desktop\usuarios-grupos.csv" -NoTypeInformation
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment