T he customer noticed some Users that seems to be duplicated when he is searching for them in some of the SMP Console pickers. He wanted to make sure that those were not a problem.
We ran the following query to see what Users appears more than once:
select Name, count (Guid)
group by Name
having count (guid) > 1
order by 2 desc
For this customer, it returned "642" Users in this condition.
We checked some of those Users that appeared more than once:
1. We went under Manage>Org. Groups and Views>Default>All Resources>Users
2. We searched for a duplicate User.
3. We opened Resource Manager for both references and under View>Inventory we reviewed the dataclasses that were created for those Users.
We were able to confirm that one User came after an AD Import and the other from Basic Inventory when reporting primary user.
This normal and expected. These Users items can be created from different processes and merged if these have similar entries. Usually the "Duplicate User Merge" (under Manage > Jobs and Tasks > System Jobs and Tasks > Service and Asset Management > CMDB) takes care of this if it is scheduled and the resource key used matches.
In order to avoid having these Users duplicates, try the following:
You may need to run this merge rule a couple of times to get all those merged.