AD import computers rule: Removing OU from import and adding it back later only adds 30% of computers in corresponding organizational group

book

Article ID: 163193

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

AD import rule may add only some computers to a designated organizational group.

Problematic scenario: OU is excluded from AD import Computer rule. Computers removed correctly. Add OU back into selection and only some part of computers appear in org.group.

n/a

Cause

Problem is caused when OU is excluded from import. While computers are removed from the group accordingly, ResourceUpdateSummary table is not properly updated, causing problem with future imports.
The issue was originated
by "spResourceUpdateSummaryFullUpdateBulk" stored procedure with a faulty logic, which leads to the (totally invisible) corruption of ResourceUpdateSummary table integrity.

Resolution

This issue has been resolved in 8.0 HF2 - See release notes for more information DOC9343

 


For those with ITMS 7.6 HF7, please refer to Pointfix attached to article INFO3459.

You can also use the attached stored procedures and manually add/update the stored procedures with the fix:

  1. Run the attached "spResourceUpdateSummaryFullUpdateBulk_ET3942705.sql" first
  2. Run then the attached "spResourceUpdateSummaryPartialUpdateBulk_ET3942705.sql"
  3. Run the AD Import rules a couple of times and the proper hashes under ResourceUpdateSummary should be regenerated.
    Note: If that is not the case after some imports, please try TECH233666 "If machines are manually moved to a different OU in Active Directory, the change is not reflected in the ITMS Console after an AD Import" and then try the AD Import again.

Very rarely the steps above still don't resolve the problem and it is necessary to manually edit the database and delete the affected records from resourceupdatesummary table for both the Inv_OU_Membership and Inv_Global_Active_Directory_Details.

Attachments

spResourceUpdateSummaryPartialUpdateBulk_ET3942705.sql get_app
spResourceUpdateSummaryFullUpdateBulk_ET3942705.sql get_app
PF_ET3942705.zip get_app