I have issue with duplicate server components affecting compliance jobs from running extended server script. Deleting the duplicates and re-discovering does work. I am not sure how many server have this issue. Is there a certain SQL query or component smart group I can run and create to gather how many duplicates exist?
I think something like:
select c1.name,c1.component_id,c2.component_id from component c1
join component c2 on c1.name = c2.name and c1.component_id != c2.component_id and c1.is_saved_explicitly = 1;