Duplicate records keep getting created by the system in Asset table

rin1
Kilo Guru

‎03-02-2022 04:00 AM

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

Preview file
72 KB
0 Helpfuls
  • 1,122 Views
10 REPLIES 10

rin1
Kilo Guru
In response to Mark Guldhammer

‎03-17-2022 05:08 AM

Thanks for your reply.

When I further investigated, the child tables (Alm_asset & alm_hardware) had 2 records with same asset tag ‘LT10022112’ and I deleted the duplicate records. The record which I deleted earlier was removed from the parent table ‘cmdb_ci_hardware’. During next import system checked for the record in parent table, it couldn’t find it and so created a new record I believe.

Found one more thing, duplicate records are getting added in child tables, not in parent tables. So I have decided to compare both parent & child table delete the irrelevant record. Also update the coalesce field of Asset tag to true in the scheduled imports as a 2nd level filter. And see if it works.

 

Thanks,

Rini

0 Helpfuls