Solved

LDAP Query to Find Users

Posted on 2014-11-25
4
92 Views
Last Modified: 2015-01-06
We are looking for an LDAP Query that will return results of only domain users who have the Telephone field populated in AD.

Any suggestions would be appreciated.
0
Comment
Question by:GR JN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 13

Expert Comment

by:Rizzle
ID: 40465412
In regards to LDAP queries which can be run to lookup accounts in AD for certain fields populated, look here:

http://social.technet.microsoft.com/wiki/contents/articles/5392.active-directory-ldap-syntax-filters.aspx
0
 

Author Comment

by:GR JN
ID: 40465419
how would be query a specific field in AD?
0
 
LVL 24

Expert Comment

by:VB ITS
ID: 40466760
Try these steps:

In Active Directory Users and Computers, right click on your domain name on the left pane > Find > in the Find dropdown box select Custom Search > click the Advanced tab > type in the following in the in the Enter LDAP query: box then click Find Now:
(&(objectCategory=person)(objectClass=user))(telephoneNumber=*)

Open in new window

LDAP-Query-for-Telephone-No..pngThis should then list all the user accounts that has the telephone number field populated.
0
 
LVL 20

Accepted Solution

by:
compdigit44 earned 500 total points
ID: 40470735
You could easily find this information out by importing the ad powershell model and doing a query for the desired information..

THe following link should point you in the write direction..
http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/20/use-powershell-to-find-non-default-user-properties-in-ad.aspx
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the method of using the Resultant Set of Policy Tool to locate Group Policy that applies a particular setting.
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
The viewer will learn how to dynamically set the form action using jQuery.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question