Deleting CMDB Serial Number table

[garimatripa]

 The CMDB Serial Number table has a lot of duplicate records and a lot of Serial Numbers with Valid False, I was trying to purge these records, what will happen if I clear out the entire CMDB Serial Number table. Will it start creating duplicates or any other issue, or should I not purge them.

[palanikumar]

Hi,

Removing Serial Number may lead to creation of duplication records. If you are using discovery, you can update the Identifier to name field if host name is unique in your environment. You can use other field like fqdn if it is accurate in your environment. If you are using different way to populate, ensure coalese of any other way to identify primary field is configured correctly.

Purging data may cause all the current relationship with task table to break (eg Incident to Configuration Item). You should be  careful if this relationship is more important in your environment