Manage

Can SQL queries access and update Active Directory?

Is possible to run SQL queries to gather information and update Active Directory?

Laura Hunter

Published: 01 Dec 2005

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Is possible to run SQL queries to gather information and update Active Directory?

Since Active Directory is an LDAP-based directory service, you can run queries and updates against it using most utilities that adhere to the LDAP specifications. This includes the built-in GUI and command-line interfaces, as well as third-party utilities such as adfind and admod from Joeware.net.

Dig Deeper on Windows systems and network management

Related Q&A from Laura Hunter

Can I modify the CN attribute of the users of an organization unit?

Active Directory expert Laura E. Hunter explains to a reader what must be done to change the default display specifiers for new users in Active ... Continue Reading

How to perform an inter-site replication between two domain controllers

Our server management expert explains how to perform an inter-site replication between two domain controllers. Continue Reading

How to disable the Open File Security Warning dialog box

Our server management expert reveals two ways that admins can disable the Open File Security Warning dialog box. Continue Reading

SearchServerVirtualization

Memory management techniques improve system performance

Prior to using memory management strategies, admins should familiarize themselves with approaches to ensure they implement ...

VMworld 2020 conference coverage

This year's VMworld conference runs virtually from Sep. 29 to Oct. 1. Read the latest news and announcements about and from the ...

4 FAQs to help master KVM management

When it comes to managing KVM, admins should do their homework and research common questions to better understand the technology ...

SearchCloudComputing

A guide to the top public cloud providers

Public cloud providers offer similar services, but there are differences from one vendor to the next. Which one is the right fit ...

10 cloud computing experts you should follow

Get up to speed on what's happening in the cloud by following some of the top voices in the industry, including those who are ...

Use this Amazon Cognito review to assess authentication tools

Amazon Cognito isn't as user-friendly as some competitors, but it does offer some unique advantages. Explore the pros, cons and ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

SearchEnterpriseDesktop

Using Task Manager to monitor memory usage in Windows 10

With the Windows 10 Task Manager, desktop admins can monitor memory usage across the desktop to identify the source of any ...

Microsoft puts Universal Print in preview

Microsoft says cloud-based Universal Print simplifies printer management by replacing on-premises infrastructure. The service is ...

How to fix a Windows 10 boot loop

A Windows reboot loop is a vicious and frustrating cycle, but there are ways you can fix a Windows 10 boot loop problem, ...

SearchVirtualDesktop

Microsoft contemplates new DaaS product, 'Cloud PC'

Unexpected consumption costs mar companies' adoption of the cloud. The reported Microsoft Cloud PC, with per-user pricing, could ...

Settle the thin client vs. PC debate for VDI endpoints

IT has the responsibility to provide virtual desktop endpoints that maximize UX based on the use cases, so admins should learn ...

Citrix-Microsoft partnership aimed at Azure, Office

A new Citrix-Microsoft team-up is intended to ease the challenges of dealing with a hybrid workforce. The companies aim to ...

LDAP (Lightweight Directory Access Protocol)

Active Directory

Implementing a custom user registry to consolidate LDAP servers and active directories?

How to size an Active Directory domain controller in Windows

Please create a username to comment.