In this article, I’ll show you how to find Active Directory Users that have attributes that are blank. For example, you want to ensure all users have the department attribute set. You can use PowerShell or the AD Pro Toolkit to find users that have specific attributes blank.
Find Empty AD Attributes using PowerShell
- Open PowerShell
- Run the following command. Change the value of $property to the attribute you want to check. In this example, I’m identifying all users that have a blank department attribute.
$property = 'department'
Get-ADUser -Filter * -Properties $property | Where-Object { $null -eq $_.$property } | Select-Object Name, $property
Find Empty AD Attributes using the AD Pro Toolkit
With the AD Pro Toolkit you can easily find multiple attributes that are blank or null.
- Click on Reports > User Reports > All users.
- Click on “Columns” to add the attributes you want to check.
- Click “Run”. Optionally click browse to search a specific OU.
- Click on any column and select “Blanks” to filter the list. This will list the user accounts that have a null value for the attribute.
You can also create custom reports with the AD Pro Toolkit and check multiple attributes at once.
