Duplicates on the Core Company Table

[Sagar Rd]

Hi All,

I need a suggestion, so on the core_company table we have duplicates with same company name. So duplicate companies have Hash value and some dont and some have the Vendor ID which is the custom field. And internally most of the assets and CI are using the compines that have the vendor ID in it.

Below are questions:

1. Is there a way that we can update the Hash value to the records.

2.How bad it would be if we delete the records with the Hash value.

Any suggestions or best approach is helpful.

Thankyou

Mourya

[Chaitanya ILCR]

Hi @Sagar Rd ,

1. Identify which among the duplicates you want to keep 
2. See if the duplicate record is being referred in any place, like see if it has any users, tasks and CIs, assets etc 

to find which tables have a field that's referring to company table go to dictionary and put filter type is reference and reference table is company

On each table check if there any record which has duplicate as value.

And move all those records to the original company record (which you decide in the first step) and then take an action on duplicate

Better don't delete it just update the name of the duplicate company with current name + "duplicate record" or something you can add and update

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Sagar Rd]

Hi

But I would like to know weather we can update the Hash Value to the new record.

Ex - Google -- Has a Hash Key value

and we have another duplicate as - Google with out Hash value (but used in multiple places)

1.So can we update the Hash value to the new record

2.can we delete the record and generate the new Hash key value for the records that dont have the value

3.Update the CI or Asset with the records that have the hash value.

Thankyou