Manage

Can SQL queries access and update Active Directory?

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

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.

This was last published in December 2005

Dig Deeper on Windows systems and network management

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Laura Hunter

How can I get certain PCs to run faster on network shared drives?

Active Directory expert Laura E. Hunter offers a tip for shortening client wait times. Continue Reading

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

What should I know about subnets when removing sites from an AD environment?

Active Directory expert Laura E. Hunter tells a reader what to keep in mind when deleting subnets associated with sites being removed in an ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Windows Server experts

View all Windows Server questions and answers

SearchServerVirtualization

VMworld 2019 conference coverage

The annual VMworld conference runs from Aug. 25 to Aug. 29. Get all the information you'll need by reading the latest news and ...

Support Hyper-V security with these important protocols

A virtual environment's security can make the difference when it comes to malicious attacks, preventing unauthorized OS or ...

VM automation strategies and benefits for sizable workloads

Before automating VMs, admins must consider several factors, such as workload size and cost efficiency. Otherwise, automated VMs ...

SearchCloudComputing

Linode GPU instances offer accelerated computing power

Linode's GPU instances are built on Nvidia's Quadro RTX 6000 GPU cards, designed to power high-performance applications and use ...

7 key characteristics of cloud computing

Companies rely on the cloud for modern app development. Learn the key features that differentiate cloud computing from ...

Alluxio updates data orchestration platform, launches 2.0

The latest version of the Alluxio data orchestration platform includes several new capabilities and features designed with hybrid...

SearchSQLServer

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 ...

How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos ...

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

SearchEnterpriseDesktop

How to take advantage of 3 features in Windows 1903 update

Windows Autopilot, reserved storage and SetupDiag are three new features in Windows 10. Here's how IT admins can use them for ...

5 Windows 10 shortcuts for desktop administrators

Admins who manage Windows 10 desktops are often overwhelmed with tedium. Here are five keyboard shortcuts for Windows 10 that can...

How to troubleshoot the blue screen of death for Windows 10

The blue screen of death is never a pretty sight. Learn how to troubleshoot and fix this dreaded issue in Windows 10, using a ...

SearchVirtualDesktop

Why perceived Citrix Cloud costs may not align with reality

Citrix is encouraging its customers to move their VDI deployments to the cloud. But the company's marketing ploys don't often ...

How to properly set user expectations about VDI performance

VDI performance can be a problem for end users, leading to a tense relationship between them and IT staff. Here's how to set ...

Explore options for VDI disaster recovery

Every VDI deployment should have a disaster recovery plan that doesn't break the bank. Explore some ways to implement VDI ...

Group Policy

Windows Management Instrumentation (WMI)

How does Azure Update Management handle integration?

How a bastion forest limits exposure of admin privileges

Microsoft puts a new face on remote server management

Microsoft's VS Code embrace prompts PowerShell editor debate

Microsoft Azure Stack tweaks causing delays, IT pros still hopeful

With June Patch Tuesday, users need a fix for the fix

Group Policy

Windows Management Instrumentation (WMI)

How does Azure Update Management handle integration?

How a bastion forest limits exposure of admin privileges

How to use Azure Active Directory differently than classic AD

Do Active Directory functional levels still matter?

Can I use third-party tools to back up Active Directory?

What's new in Azure Active Directory Connect?

Windows Management Instrumentation (WMI)

Monitor Active Directory replication via PowerShell

Manage Linux servers with a Windows admin's toolkit

Use PowerShell for help with DNS server management

What are the guidelines for a better Active Directory backup?

Can I restore Active Directory to different hardware?

How to plan an Active Directory backup and restoration

Solving data consistency problems from Active Directory tombstones

Please create a username to comment.

VMworld 2019 conference coverage

Support Hyper-V security with these important protocols

VM automation strategies and benefits for sizable workloads

Linode GPU instances offer accelerated computing power

7 key characteristics of cloud computing

Alluxio updates data orchestration platform, launches 2.0

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

How SQL Server DevOps processes help break down data silos

Key features to create a SQL Server audit trail in databases

How to take advantage of 3 features in Windows 1903 update

5 Windows 10 shortcuts for desktop administrators

How to troubleshoot the blue screen of death for Windows 10

Why perceived Citrix Cloud costs may not align with reality

How to properly set user expectations about VDI performance

Explore options for VDI disaster recovery

Dig Deeper on Windows systems and network management

Related Q&A from Laura Hunter

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.