Tuesday, November 9, 2021

PowerShell Code to get all AD Users and attributes.


#Get All AD Users

$Table = @()

$Arrayofmembers = Get-ADUser -filter {objectClass -eq "user"}  -searchbase "DC=LOWES,DC=com" -Properties samaccountname | Sort-Object -Descending

[int]$count = $Arrayofmembers.Count


Foreach($A in $Arrayofmembers) {

$User = Get-ADUser $A.SamAccountName -Properties * | select name,cn,mail,physicaldeliveryofficename,title,extensionattribute12,extensionattribute5,extensionattribute10,extensionAttribute7, @{n=’MemberOf’; e= { ( $_.memberof | % { (Get-ADObject $_).Name }) -join “;” }}

[int]$count = $count - 1

Write-Host "Getting $($a.samaccountname) - $count to go"

$Obj=New-Object PSObject

    $Obj | Add-Member -Name "name" -MemberType NoteProperty  -Value $User.name

    $Obj | Add-Member -Name "CN" -MemberType NoteProperty  -Value $User.cn

    $Obj | Add-Member -Name "physicaldeliveryofficename" -MemberType NoteProperty  -Value $User.physicaldeliveryofficename

    $Obj | Add-Member -Name "Title" -MemberType NoteProperty  -Value $User.title

    $Obj | Add-Member -Name "lowesEffectiveJobCode" -MemberType NoteProperty  -Value $User.extensionattribute12

    $Obj | Add-Member -Name "lowesEffectiveDeptNumber" -MemberType NoteProperty  -Value $User.extensionattribute5

    $Obj | Add-Member -Name "extensionattribute10" -MemberType NoteProperty  -Value $User.extensionattribute10

    $Obj | Add-Member -Name "lowesEffectivePhyLocationCode" -MemberType NoteProperty  -Value $User.extensionAttribute7

$Table += $obj

}

$Table | export-csv "c:\Temp\ADUsers.csv" -NoTypeInformation




No comments:

Post a Comment