Searching Active Directory for “Office”

Question

Our AD is a bit of a mess and I'm trying to tidy things up a little bit. I'm trying to search AD to find anything in the 'Office' field. For example if 'Head Office' is in that box I need to find users who have this entered. See the image below.

I've tried custom searches but the closest I've found is 'Office Location' which returns nothing. Google is less than helpful on this occasion.

Any tips welcomed.

Answer 1

Most fields in active directory aren't really used for anything but custom-development. You can do custom-searches against Active Directory... but they're far-less than pretty. The "Office" field you're talking about is called the "physicalDeliveryOfficeName" in Microsoft's LDAP lookups... so you'd build a query like:

(&(objectCategory=person)(objectClass=user)(physicalDeliveryOfficeName=Head Office))

More information about the search syntax can be found here.