A recent request we had was to count the number of objects in each OU in AD, so we could identify which ones were not being used any more. To achieve this we used a PowerShell script, and exported to a csv file.
I have seen a number of scripts that will count the number of Users, Computers or Groups in an OU, but we wanted to combine these, so we can see both object counts in one report.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
Get-ADOrganizationalUnit -filter * -property Description | foreach { $u=Get-ADuser -filter * -searchbase $_.distinguishedname -searchscope Onelevel $totalu=($u | measure-object).count $Enabledu=($u | where {$_.Enabled} | Measure-Object).count $Disabledu=$totalu-$Enabledu $c=Get-ADcomputer -filter * -searchbase $_.distinguishedname -searchscope Onelevel $totalc=($c | measure-object).count $Enabledc=($c | where {$_.Enabled} | Measure-Object).count $Disabledc=$totalc-$Enabledc $g=Get-ADGroup -Filter * -searchbase $_.distinguishedname -searchscope Onelevel $Totalg=($g | measure-object).count New-Object psobject -Property @{ Name=$_.Name; OU=$_.Distinguishedname; Description=$_.Description; TotalUsers=$Totalu; EnabledUser=$Enabledu; DisabledUser=$Disabledu TotalComputers=$Totalc; EnabledComp=$Enabledc; DisabledComp=$Disabledc TotalGroups=$Totalg } } | Export-csv c:\temp\OUsObjects.csv -NoTypeInformation |
This gives you a great output of both the Users, Computers or Groups in each OU in your domain, including both Enabled and Disabled counts.
Great script. Thank you
How would this script need to be modified to accept an input list of groups I need the information on?
Hi Florian,
Are you just looking to get the number of Users and Computers that are members of the Groups you have listed in a csv file?
awesome, thank you Ashley. added another line to search for distro and edited existing to give security, changed scope to 2 and got what I needed in minutes 🙂