Active Directory users missing from the LDW_Users table
search cancel

Active Directory users missing from the LDW_Users table


Article ID: 254822


Updated On:


Information Centric Analytics


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.


Release : 6.x

Component : Active Directory Import Utility


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


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;
UPDATE dbo.[Server]
SET  IsEnabled = 1
WHERE ServerID =