Hi @janindiadoc_1 ,

1. as long as there is no Reference Qualifiers which filters out the new table, it should be no issue. Even there is a filter, the sys_id will stay in the reference field - therefore also the link to the CI. Only if you change the reference you will not see this CI anymore - but only if there is a Reference Qualifier filtering this out.

2. There is only a de-duplication engine available for CIs not for asset. I would try to write a fix script which search for duplicate assets with same name or other criterias like serial numbers and merge them (means choosing one main asset and switch all references to duplicates to the main asset) and then deleting the others. Maybe based on this approach https://www.jamesfarrer.com/?id=358.

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!