How to remove duplicates host in object schema

[Risikanta Pradhan]

In data center after synchronize in import configuration. Then showing some host information with other information . So in the hosts if there is some duplicate hosts are coming so how to remove one from that host in the object schema.

[Jeroen Poismans · Accepted solution]

Hi!

In your import if you want Host to be unique, you should mark it as identifier OR set unique property on the attribute in the object type configuration.

At this point I don't think there is an easy way to remove duplicates. What you could do

• Find all objects of that type, created around the time of the import (using IQL)
• Remove those objects (only if they are not lined to tickets yet)
• Change the unique property of the host attribute and in the import put it as an idenifier
• Re-run the import

Hope this helps!

Regards,

Jeroen

[Risikanta Pradhan]

Thanks Jeron, for the reply

But the duplicate hosts which is already present in object schema how can I remove that hosts without using manual delete.

Thanks, regards

Risikanta 

[Jeroen Poismans]

Hi,

When you have found the object with IQL, you can delete them in Bulk, but be careful with this that you have the right selection of objects in your IQL.

Regards,

Jeroen

[Risikanta Pradhan]

Thanks Jeron for the reply 

I can't understand where I actually write the IQL or delete. So you have any documents or any screenshot for how to delete.

Thanks, and Regards,

Risikanta 

[Jeroen Poismans]

Well,

First you have to find the objects created by the import (you have to know when the import has run), you don't need IQL, you can do this with the basic search also:

Then, after being absolutely sure you got the right objects, you can delete them. Do NOT delete the ObjectType:

You might want to read up on Assets and AQL:
https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/

Regards,

Jeroen

[Risikanta Pradhan]

Thanks Jeron for this documentation

So that is applicable for only when import the file. But already I have more than 100 duplicate  host in my assets so how delete these hosts any idea about this.

So already I have more than 100 duplicate host so how to delete all the duplicate and keep only one between then in duplicates.

Regards

Risikanta Pradhan