Microsoft Active Directory (LDAP)

📘

TL;DR

To integrate Active Directory with Query:

• Setup the required LDAP connection parameters for Active Directory mentioned in the 'Prerequisites' section of this document.
• Add an Active Directory source in Query with the connection parameters.
• Test the integration with Test connection link.
• Perform searches for AD users and devices.

Overview

Active Directory is a centralized database for managing user identities and resource access in a Windows-based network environment. By integrating with Query, you can:

• Search context for Active Directory-managed users and devices.

Prerequisites

In order to add Active Directory as a connection source in Query, make sure you have the following connection parameters:

• Active Directory Server IP/Hostname
• Username
• Password
• Port - 389/636
• CA Certificate File

Adding a connection source in Query

1. Go to the Connections page, click Add Connections, and select Active Directory from the Identity and HR category.
2. In the General tab, add the following details

• Active Directory Server IP/Hostname
• Username
• Password
• Port - 389/636
• CA Certificate File

3. Click the Save button on the top right corner of the screen to save the connection source.
4. To test the connection credentials, click on 'Test Connection.' You will see a successful connection message if the credentials are valid. If the test connection fails, then check if the connection parameters are correct. If necessary, change appropriately and retest.

Resources

• Setting up LDAPS on Active Directory -[<https://techcommunity.microsoft.com/t5/sql-server-blog/step-by-step-guide-to-setup-ldaps-on-windows-server/ba-p/385362>]