ICA - Active Directory Integration Pack - Adding a Domain Controller for Existing Domains or after the Active Directory Integration Pack is installed

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

A Domain Controller that was not part of the original integration has data users want to bring in to ICA. To do this, a user must add a Domain Controllers to the Active Directory Integration Pack.

N/A

Environment

N/A

Cause

Need to add data from a Domain Controller to the ICA platform for further context and analysis.

Resolution

• On the ICA SQL Server, navigate to the AD Import Utility folder for the domain you will be adding DCs for.
• Run the Update query to add the Domain Controller to the Data Warehouse.

INSERT INTO [<<ActiveDirectoryDW Name>>].[dbo].[Server] (ServerName, Domain, UserName) VALUES ('<<Server Name>>:<<Port>>' , '<<DomainName>>' , '<<DomainName>>\<<UserName>>')

 

• Run the executable with this command line to encrypt the service account password.

<driveletter>:\ ImportADUsersAndComputers.exe -setapipassword <<ServerID>> <<PasswordForUserName>>

 

• Run the executable to bring in the latest AD data to the respective Active Directory DW

<driveletter>:\ ImportADUsersAndComputers.exe

 

Example

Run this query for each domain controller to be added to the newly created DW

INSERT INTO [ActiveDirectoryDW_INTL].[dbo].[Server] (ServerName, Domain, UserName) VALUES ('10.10.10.2:389' , 'ACME-INTL' , 'ACME-INTL\RiskFabric')

 

Run the executable with this command line to encrypt the service account password.

REM CD to the folder the .exe is installed to. ImportADUsersAndComputers.exe -setapipassword 2 10.10.10.12DCPasswordHere2!

 

Run the executable to bring in the latest AD data to the respective Active Directory DW

 

REM CD to the folder the .exe is installed to. ImportADUsersandComputers.exe