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

How to evaluate VDI hardware requirements

VDI has specific hardware needs that servers hosting other virtualized workloads may not meet. Learn how to gauge VDI hardware ...

VMworld 2020 news and 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 ...

QEMU 5.0 continues a legacy of emulation

Admins looking for an alternative tool for emulating hardware should consider QEMU, which supports x86, PowerPC, ARM and SPARC ...

SearchCloudComputing

Microsoft's SpaceX partnership sends Azure to the final frontier

Microsoft has partnered with SpaceX to tie Azure to low-orbiting satellites. The company also introduced a modular data center to...

How to design and implement a cloud governance framework

An organization that wants to control its cloud environment should look closely at how well it adheres to these four key pillars ...

AWS Outposts: What you need to know to get started

AWS Outposts is a managed device that brings Amazon cloud services into your data center. Review its requirements, use cases 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

A complete guide to troubleshooting Windows Hello

Windows Hello has several common issues that administrators may need to troubleshoot. Find out what those issues are here and ...

Comparing Jamf vs. Fleetsmith for macOS management

Like any decision around purchasing a business technology, the Jamf vs. Fleetsmith debate for Apple device management comes down ...

Mac users key in defending against Apple T2 chip flaw

IT pros should lean on Mac users to protect corporate networks against exploiters of the Apple T2 chip vulnerability. Hard drive ...

SearchVirtualDesktop

8 key VDI deployment best practices

When IT plans for its VDI deployment, it must factor in best practices for the setup process, such as considering client options ...

How to calculate VDI costs and keep them to a minimum

When the true cost of VDI is hazy, it's a good idea to make a comprehensive calculation. Determine how to factor in costs related...

VMware bolsters Workspace One security with Secure Access

With the new Secure Access, VMware says remote workers will have a better and more secure way to use their Workspace One virtual ...

LDAP (Lightweight Directory Access Protocol)

LDAP injection

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.