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 Microsoft Active Directory Design and Administration

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Laura Hunter

How can I change the IP address of a DC running Windows Server 2003 Active Directory?

Active Directory expert Laura E. Hunter offers some advice for changing the IP addresses of domain controllers. 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

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

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

Amazon Virtual Private Cloud 101: Features, pricing and more

Evaluate the key features of Amazon Virtual Private Cloud, learn about its advantages and disadvantages, and consider pricing and...

Find a way forward in the cloud vs. virtualization debate

IT admins weighing the options available for cloud and virtualization services against use cases and economics must navigate a ...

Expedite Ansible KVM provisioning with automation

Creating KVM virtual machines with virsh and virt-install can be onerous. Use Ansible to automate deployment with templates and ...

SearchCloudComputing

Four tips for a successful hybrid cloud POC

A hybrid cloud proof of concept is an important step to ensure a deployment will fully meet IT and business needs. Mind these ...

Google acquisition aims to simplify big data projects

Google Cloud analytics tools are well-regarded for their technology, but not necessarily for their ease of use. Google's ...

Are you on the right cloud computing career path?

As more advanced cloud technologies and deployment models emerge, it's important to future-proof your career. Check your resume ...

SearchExchange

Cloud-based email security tools barricade entry to Exchange

The pressure is on Exchange administrators to avoid a ransomware outbreak that cripples the on-premises email system. Cloud-based...

Migrating public folders requires extensive planning

Do your homework to find the right option for public folders when making a move to Exchange Online. Here are guidelines to help ...

Using Microsoft Exchange certificates requires planning

Exchange certificates typically require minimal management effort after they have been set up, and they offer a secure means of ...

SearchSQLServer

Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of...

Why running SQL Server on Docker is no longer frowned upon

Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a ...

What the Microsoft GDPR compliance toolkit offers for SQL Server

The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database ...

SearchEnterpriseDesktop

Seven factors that make up an effective email phishing test

The best way for IT to improve email phishing security is through comprehensive testing, which helps identify which users are ...

Citrix Analytics service brings hope for better security

As it becomes more difficult to monitor and secure applications and data, Citrix's security analytics platform is getting more ...

Citrix Workspace app holds potential, raises questions

At Synergy 2018, Citrix introduced a new secure digital workspace that provides users unified access to their virtual desktops ...

SearchVirtualDesktop

Six ways to simplify Citrix App Layering

App layering can deliver a lot of benefits to IT administrators, but only if they know how to keep management simple. Start by ...

Find the right user profile management software

Determine the right profile management platform for your company and take a close look at personalization, recovery, cloud, UEM ...

ControlUp targets virtual desktop, server overprovisioning

If IT pros overprovision virtual desktops and servers, they waste money and resources. But there are other problems associated ...

Related Resources

Dig Deeper on Microsoft Active Directory Design and Administration

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.