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

Proxmox VE 6 and later offers container features, better security

Proxmox VE, an open source virtualization management product, provides admins with several features, such as VM live migration, ...

Top considerations for VMware GPU virtualization

Virtualizing GPUs is not easy without the proper considerations. In VMware environments, admins should consider licensing, ...

Understand the differences in VM vs. container vs. serverless

VMs, containers and serverless computing provide organizations with application development flexibility, but they add management ...

SearchCloudComputing

5 ways to reduce cloud costs

Organizations need the right strategies in place to avoid cloud cost pitfalls. Stay within your budget with these cost management...

Confront cloud security challenges with these 5 tips

Security gets complicated when the cloud overlaps with other technologies, such as AI and serverless. Review these common risks, ...

10 open source cloud security tools to know

While cloud providers offer native security tools, there also are plenty of useful open source options. Here's a sample of open ...

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

Ivanti updates its unified endpoint management

Ivanti Unified Endpoint Manager 2020.1 was released this month, emphasizing remote work features for IT pros and noting the ...

AMD's Ryzen, Epyc power surge in desktops, laptops, data centers

AMD's Ryzen and Epyc processors, Zen and RDNA architectures, and 7-nm technology are powering the chipmaker's record revenue and ...

How SCIM can automate user provisioning

Using SCIM allows users to access resources within unrelated partner environments automatically without organizations needing to ...

SearchVirtualDesktop

5 tips to optimize CAD application performance for VDI

CAD applications that run on VDI require special treatment on the back end by admins, and this video explains how IT can optimize...

How to fix 8 common remote desktop connection problems

When the connection between a desktop and its host fails, it's time to do some remote desktop troubleshooting. Check firewalls, ...

Design firm ups productivity with Workspot

Mead & Hunt is using Workspot virtual desktops to enable remote work during the pandemic -- and it's paying off in ways the firm ...

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.