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