Duplicate Users after Basic Inventory or User AD Import

Products

• IT Management Suite
• Asset Management Solution

Issue/Introduction

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)
from vRM_User_Item
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.
 

Environment

ITMS 8.0 and later

Cause

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.

Resolution

In order to avoid having these Users duplicates, try the following:
 

1. In a Symantec Management Platform Console, click on the Manage > Jobs and Tasks 
2. Click on to expand the folders System Jobs and Tasks > Service and Asset Management > CMDB.
3. Clone Resource Merge Rule.
4. Click on the Resource Type drop-down list and select Users.
5. Click on the "Merge key" drop-down list and select Resource Name.
6. Click on the "Save changes" button.
7. Click on the New Schedule button.
8. Click on the Schedule button. The merge then starts.

You may need to run this merge rule a couple of times to get all those merged.