Due to a mistake made by one of our programmers we are in a situation where there are several users who have a space " " in some of their AD fields. Most notably their cell phone field. What the programmer did was inadvertently pass a space " " character rather than a null value. What I would like to do is find a way to clean this up.
I have tried doing a query in ADUC to find users where the mobile number starts with a space " " but it returns all users in AD.
Is there a way to search for a space " " character in a query.