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

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

Server virtualization in DevOps continues to offer advantages

Virtualization's role in DevOps technologies continues to persevere by providing strong isolation, flexible OS options and an ...

How to implement GPUs for high-performance computing

IT managers must take advantage of advances in virtualization technology, such as virtual GPUs, to efficiently manage ...

7 HPC workload virtualization best practices

If you are running high-performance computing workloads in a virtual environment, use our handy checklist to see if you are ...

SearchCloudComputing

Oracle Cloud Infrastructure SVP shares competitive strategy

Former AWS engineer Clay Magouyrk was one of the first people Oracle hired to build OCI and says Oracle has plenty of time -- and...

Zenoss automates transition to cloud-based IT monitoring

In an effort to improve the user experience while transitioning from on-premises to cloud-based monitoring, Zenoss has added new ...

How to modernize apps as part of the cloud migration process

Take stock of your applications and modernize them where appropriate as part of a cloud migration. Learn about the benefits of ...

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

DaaS may encourage organizations to adopt Macs and Chromebooks

New options for delivering remote Windows apps in the cloud, combined with the maturity of SaaS apps, Chromebooks and Mac ...

Zoho adds new Zoho One features, management application

Zoho One customers can now make phone calls using Zoho's telephony platform, extend provisioning through custom apps and use the ...

4 steps to check application compatibility with Windows 10

Before a Windows 10 migration, IT admins should make sure all applications are compatible with the new OS. Here are four steps to...

SearchVirtualDesktop

Navigate Office 365 licensing issues with VDI

Office 365 can come with some tricky licensing situations, especially for VDI admins. Explore this rundown of licensing issues ...

St. John's Health modernizes with digital workplace technology

St. John's Health modernized its workplace experience by simplifying IT's management of applications with VMware's Workspace One.

How to use Samsung DeX for remote desktop clients

Organizations can harness the capabilities of Samsung DeX and Windows Virtual Desktop to transform mobile devices into thin ...

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.

Server virtualization in DevOps continues to offer advantages

How to implement GPUs for high-performance computing

7 HPC workload virtualization best practices

Oracle Cloud Infrastructure SVP shares competitive strategy

Zenoss automates transition to cloud-based IT monitoring

How to modernize apps as part of the cloud migration process

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

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

DaaS may encourage organizations to adopt Macs and Chromebooks

Zoho adds new Zoho One features, management application

4 steps to check application compatibility with Windows 10

Navigate Office 365 licensing issues with VDI

St. John's Health modernizes with digital workplace technology

How to use Samsung DeX for remote desktop clients

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.