Old Security Group references still remain after User AD Import in the Inv_Security_Groups data class
Last Updated May 03, 2017
Some Users are not cleaning up their references from previous Security Groups associations from "Inv_Security_Groups" table.
For example, you have John Doe on Security Group called "Floor 1". Later on you move John Doe from Security Group "Floor 1" to Floor 2", removing him completely from "Floor 1". After running an AD Import for those Security Groups, you check the "Inv_Security_Groups" table and see that John Doe exists on both Security Groups.
select * from Inv_Security_Groups where [User Name] like '%JohnDoe%' and [Group Name] like '%Floor%'
It returns the old and new security group.
A fix has been added to ITMS 8.1 RU1 (current ETA of end of May 2017) and ITMS 8.0 Post-HF6 (See INFO4241)
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe