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

LDAP (Lightweight Directory Access Protocol) LDAP (Lightweight Directory Access Protocol) is a software protocol for enabling anyone to locate organizations, individuals, and other resources such as files and devices in a network, whether on the public Internet or on a corporate intranet.

Event Tracing for Windows: A fresh look at an old tool Though over a decade old, the Event Tracing for Windows utility might be the best troubleshooting tool that many admins have never heard of.

Securing naming and directory services for application defense-in-depth There are several aspects of naming and directory services when it comes to security. In this tip, part of the SearchSecurity.com Application Security School lesson, learn how to secure LDAP, as well as how application security teams can work with infrastructure security teams to secure naming and directory services.

Creating an active GAL on Outlook 2003 and 2007 Find out how to configure a newly-created GAL so it's active on both Outlook 2003 and 2007, ensuring Outlook is updated when a new user is added.

LDAP signing requirements for various directory configurations While there is no longer a standard directory configuration, it is still possible to implement LDAP signing in most environments. Learn more about LDAP signing requirements from IAM expert Randall Gamby.

Taming the LSASS.exe process for Active Directory performance and security Many admins have trouble understanding how the Local Security Authority Subsystem works. This article breaks down the purpose of LSASS and explains why it can sometimes result in network performance problems.

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

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

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

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

Understand and deploy IBM Cloud for VMware Solutions

The IBM-VMware partnership has provided a platform for admins committed to VMware technologies who also require cloud benefits ...

How AppDefense works to detect app and VM anomalies

AppDefense, a newer addition to the VMware security tool portfolio and part of the vSphere Platinum edition, helps organizations ...

Import and export Hyper-V VMs with Hyper-V Manager and PowerShell

When migrating VMs, admins can use Hyper-V Manager's export and import capabilities for small sets of VMs or PowerShell for ...

SearchCloudComputing

A primer on Alibaba Cloud for Western enterprises

When Western cloud users think of major cloud providers, it's typically the top three: AWS, Google Cloud Platform and Microsoft ...

AWS, Azure and Google peppered with outages in same week

Cloud outages hit AWS, Microsoft Azure and Google Cloud within the past week, an outcome that suggests customers must take a more...

Google to unveil post-Chronicle cloud cybersecurity plans

Google plans to discuss its cloud cybersecurity portfolio at a conference next week, with the capabilities developed by Chronicle...

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

Project Limitless' 5G PC and what desktop admins need to know

Qualcomm and Lenovo have partnered to produce a 5G-enabeled PC that could be a game-changer for remote workers. IT must prepare ...

Jamf Protect offers visibility, protection for macOS admins

Jamf Protect, the new endpoint security software announced at JNUC 2019, provides organizations with a native macOS tool that ...

Compare Windows 10 OS editions to determine the best fit

Organizations deploying Windows 10 must choose between multiple Windows 10 OS editions. Delve into the different features that ...

SearchVirtualDesktop

Compare offerings from 3 major desktop-as-a-service providers

Three desktop-as-a-service providers, Citrix, VMware and Microsoft, all offer virtual desktops as a part of their cloud services....

How to use VMware Horizon Performance Tracker

A good user experience is essential for VDI. Learn how to install and use VMware Horizon Performance Tracker to take the pulse of...

10 Microsoft Ignite 2019 sessions for VDI admins

VDI admins attending Microsoft Ignite 2019 could benefit from attending these 10 sessions. This guide can help to build a session...

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.