Need to run background script to find duplicate CI names using a unique name on another column

[Looper23]

I want to run a background script so I can find duplicate CI's using the name column but have unique value in another column (discovery_source). In this case I should return two results; Notifier and Scan. Can anyone help? 

[Mohith Devatte]

@Looper23  any luck ?

[Looper23]

I'm trying it in my Dev instance and the transaction seems to be taking a very long time to process. Still waiting on the result. In my personal instance it seems to be working but I can confirm as soon as the transaction is completed 

[Mohith Devatte]

@Looper23 sure i think there must be many records and if it running long its working fine .Update me if it not working 

if working close the thread by marking my answer correct

[Looper23]

I'm not sure if this Script is the best idea as the it will have run the Glide Record query almost 250k times so it can really impact the performance. In my Personal instance I only had few records but I think it is impacting the performance of my Dev instance and making it unusable.