Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,331 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