Duplicate records keep getting created by the system in Asset table

rin1
Kilo Guru

Hi Experts,

Duplicate records getting created by the system very often in the Asset table. I have checked the transform maps, only sys_id is made Colaesce. Any idea why these duplicates getting created. Its really a stress to maintain Asset table.

find_real_file.png

Thanks,

Rini

10 REPLIES 10

Prathamesh1
Giga Guru

Hi,

check this link: 

How to prevent having duplicate record in asset table?

Hope this helps!

Regards,

Prathamesh.

Ken Neikirk1
Tera Guru

I would coalesce on serial number and/or asset tag

Yes I have decided to coalesce asset tag and see what happens.

 

Thanks for your reply!

Joe Ryder
Tera Expert

These are being duplicated from discovery or from upload of assets from spreadsheet? What are the discovery sources for each of these records?