search cancel

Active Directory users missing from the LDW_Users table

book

Article ID: 254822

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

User accounts are missing from the Information Centric Analytics (ICA) console and from the LDW_Users table in the RiskFabric database. No errors are logged for the Bay Dynamics AD Connector Job under the SQL Server Agent, or in the Active Directory Connector Utility log.

Environment

Release : 6.x

Component : Active Directory Import Utility

Cause

The column IsEnabled for the domain controller specified in the ActiveDirectoryDW table Server is set to 0 (False).

Resolution

To enable a disabled server in the ActiveDirectoryDW.Server table, follow this procedure:

  1. Open SQL Server Management Studio (SSMS)
  2. Connect to the Database Engine hosting the ActiveDirectoryDW database
  3. In Object Explorer, navigate to Databases > ActiveDirectoryDW > Tables
  4. Right-click the table dbo.Server and select Edit Top 200 Rows...
  5. In the editor window, change the value for the column IsEnabled from False to True and press the Return or Enter key

Alternatively, the following statement can be run in SSMS:

USE ActiveDirectoryDW;
GO
UPDATE dbo.[Server]
SET  IsEnabled = 1
WHERE ServerID =
;