Duplicate department records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 06:33 AM
Hello!
Need inputs on handling a data inconsistency scenario.
In our department table, few departments manually added via XML and users got assigned to them.
Again, from workday integration same departments data was created and some other users were assigned to them.
Now on SP portal, record producer forms have department question and users are seeing duplicate records and confused with what to select.
Now how to delete duplicate records?
Please guide me if you have fixed similar issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 06:41 AM - edited 02-21-2025 06:42 AM
@Vadla Srimaan You need to address this issue with following steps.
1. Identify the duplicate departments: As a starting point, you need to identify the duplicate department first, name could be a criteria using which you can identify what all departments are duplicate on your instance.
2. Identify the users: Identify all users who are associated with the duplicate department. This is needed as you need to map the correct department on all such user records
3. Delete the duplicate entry: Once the correct department is mapped to user records, you can delete the duplicate department.
You can write a fix script with Rollback option checked to perform all these steps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 06:43 AM
@Vadla Srimaan - Adding to sandeep
Make sure you update the records which user raised with proper department values from background script before deleting the duplicate record.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 07:09 AM
Just to add, expert's( @Sandeep Rajput @Voona Rohila ) perspective, this is purely a data issue. After deleting (which you can do manually), make sure to update the reports/dashboard where this data has been used as a filter.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 08:19 AM
Hi @Sandeep Rajput ,
There is no specific identifier. For example, in the image below both departments have different users assigned to them.