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

Learn the differences between VM snapshot vs. backup

When admins build their VM management and DR strategy, they must understand the differences between backups and snapshots to ...

How to perform a Hyper-V to VMware migration

Before you migrate from Hyper-V to VMware, you should take a comprehensive inventory, set an agreed-upon schedule and communicate...

10 benefits of server virtualization for businesses

Server virtualization has come a long way since the early 2000s. It's not only good for large enterprise data centers; smaller IT...

SearchCloudComputing

Microsoft ACS going GA with preview of Teams integration

Microsoft Azure Communication Services is now in preview, with deep integration with Microsoft Teams so developers can build ...

Modernize and migrate mainframe apps to the cloud

Mainframe apps are typically difficult to move to the cloud without modernization. Review migration options and determine if it ...

How to create snapshots for Azure VMs and managed disks

Learn best practices for creating VM snapshots in Microsoft Azure. Follow along with these step-by-step examples to try in your ...

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

Microsoft makes Productivity Score useful to tech buyers

Microsoft's Productivity Score update lets an organization's tech buyers monitor, without the help of IT staff, the average ...

Microsoft makes Universal Print generally available

Microsoft wants Universal Print to replace on-premises print servers. The cloud service provides printer management and ...

Microsoft bolsters data security in 365

Microsoft said the latest 365 security features provide better protection for corporate data. The improvements guard sensitive ...

SearchVirtualDesktop

VMware Horizon sizing guide for Windows 10 environments

When an organization needs to deploy a VMware Horizon VDI environment with Windows 10 desktops, it must plan for and consider a ...

Citrix launches well-being microapps for Workspace

Citrix will help companies measure employee wellness with simple programs that can take surveys and distribute health and ...

Choose a Windows Virtual Desktop managed service provider

Windows Virtual Desktop can present numerous management and deployment challenges for IT admins, so organizations may want to ...

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