Querying Active Directory Data from SQL Server. Problem. My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server  In this tip we walk through how you can query Active Directory from within SQL Server Management Studio. Solution. In this tip Ill show you how to query Active Directory using linked servers and the OPENQUERY command. Create Linked Server. First thing well do is create our linked server, Active Directory Service Interface also known as ASDI, to Active Directory using the code below Make sure you change the rmtuser and rmtpassword variables to a login and password that has access to your Active Directory. Querying Active Directory. Once the linked server is created we can now setup our query to return the information we need. First, youll need to ask your NetworkSystems Administrator for your LDAP info then we can continue to the query. Here is how the LDAP connection is broken down For our example it looks like this LDAP DOMAIN. OUPlayers,DCDOMAIN,DCcom. MSPPError=-2147217396' alt='Find Sql Server In An Active Directory Domain Controller' title='Find Sql Server In An Active Directory Domain Controller' />LDAP Domain. OUPlayers this is the Organization Unit, in our case Players. DC this is the Domain Name broken up by domain and extension name. Find Sql Server In An Active Directory Domain Controller' title='Find Sql Server In An Active Directory Domain Controller' />So. LDAP Domain. Controller. Name. OUOrganizational. Unit,DCDOMAIN,DCNAME According to the problem, this user needs to return the companies email addresses and phone numbers. To do this we can use the code below note you will need to change your domain information for this to work SELECT FROM Open. Query. SELECT display. Name, telephone. Number, mail, mobile, facsimile. 123 Solitaire Forty Thieves. Telephone. Number. FROM LDAP DOMAIN. OUPlayers,DCDOMAIN,DCcom. After a recent incident with Outlook, I was wondering how I would most efficiently resolve the following problem Assume a fairly typical small to medium sized AD. Warning Do not in any way delete the computer object from Active Directory or Active Directory Sites and Services because the domain controller will not function. Tutorial 802. 1X Authentication via WiFi Active Directory Network Policy Server Cisco WLAN Group Policy. My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this. WHERE object. Class User. AS tbl. ADSI. ORDORDER BY displayname. As you can see this query will return Active Directorys Display Name, Telephone Number, Email Address, Mobile Number, and Fax Number. Also note, that when you query Active Directory it actually creates the SELECT statement backwards. I started the SELECT statement with SELECT displayname. Name last as shown below. If you wanted to view more columns for each user we can use the below code to display fields such as First. Name, Office, Department, Fax, Mobile, Email, Login, Telephone, Display Name, Title, Company, Pager, Street Address, and more. SELECT FROM Open. Query. SELECT streetaddress, pager, company, title, display. Name, telephone. Number, s. AMAccount. Name. mail, mobile, facsimile. Telephone. Number, department, physical. Delivery. Office. Name, givenname. FROM LDAP DOMAIN. OUPlayers,DCDOMAIN,DCcom. WHERE object. Class User. AS tbl. ADSI. ORDER BY displayname. You can also filter out columns using a WHERE clause. In this example I only want to return results where users have a fax number. SELECT FROM Open. Query. SELECT streetaddress, pager, company, title, display. Name, telephone. Number, s. AMAccount. Name, mail. Telephone. Number, department, physical. Delivery. Office. Name, givenname. FROM LDAP DOMAIN. OUPlayers,DCDOMAIN,DCcom. WHERE object. Class User. AS tbl. ADSI. WHERE facsimile. Telephone. Number IS NOT NULL. ORDER BY displayname. Next Steps. To view all the Active Directory attributes click here. To view how to get Active Directory Users and Groups with SSIS check out this tip from Ray Barley. Last Update 2. 01. About the author. Brady Upton is a Database Administrator and Share. Point superstar in Nashville, TN. View all my tips.