Customer reported that computers that get moved in AD, don't have the change reflected in the SMP Console under the respective AD Import filters.
He demonstrated one machine that he had moved in AD and after the import it stopped showing up in any of the AD groups in the console.
Note: this also applies to Users.
Known issue. Usually the issue is related to hashes getting out of sync for some resources where the proper reference between "ResourceUpdateSummary" and "Inv_OU_Membership" tables is missing. In this type of issue, the affected machines, or users, usually don't have an entry under "Inv_OU_Membership" table.
The root cause has been addressed with the ITMS 8.0 release, so those changes should prevent this issue for happening for now on. However, if the issue was previously present, the following steps need to be followed:
Note: if the issue is related to users, please see the modified queries that apply to users rather than computers.
Run again the respective AD Import rule (Complete (Full) import is preferred).
Run the Delta resource membership update schedule and check if the missing computers are now present.
Also refer to KB 163193
"AD import computers rule: Removing OU from import and adding it back later only adds 30% of computers in the corresponding organizational group"
Queries that apply to users:
--Identify Users that were imported via AD Import that are not re-imported again due to their hashes
select vc.name, * from ResourceUpdateSummary rus
join vRM_User_Item vc on vc.Guid = rus.ResourceGuid
join (select c.Guid, COUNT(_id) as oucount from vRM_user c
left join Inv_OU_Membership oum on c.Guid = oum._ResourceGuid
group by c.guid) ou on ou.Guid = rus.ResourceGuid
where InventoryClassGuid = '7FDC0F4A-6B51-44CB-9287-F69A2
and ou.oucount != rus.[RowCount]
--Clear out all the incorrect references, so the next AD Import those resources can be updated properly:
delete rus from ResourceUpdateSummary rus
join vRM_User_Item vc on vc.Guid = rus.ResourceGuid
join (select c.Guid, COUNT(_id) as oucount from vRM_user c
left join Inv_OU_Membership oum on c.Guid = oum._ResourceGuid
group by c.guid) ou on ou.Guid = rus.ResourceGuid
where InventoryClassGuid = '7FDC0F4A-6B51-44CB-9287-F69A2
and ou.oucount != rus.[RowCount]