How to find the duplicates assets using AQL query or any other way in Jira service management cloud?

[Risikanta Pradhan]

There is similar/duplicates assets in my object schema for ex: 1000 assets. Around 200 duplicates hosts are in my object schema so how to find actual duplicates object schema. 

[Kris Dewachter]

Hi @Risikanta Pradhan ,

This is some documentation on how you could find duplicate objects - https://confluence.atlassian.com/jirakb/find-duplicate-assets-using-aql-1216971340.html

Unfortunately, it requires manual searching. There is no AQL function that would allow you to find duplicates automatically. 

The best alternative I can think of is doing an export to a csv file, import it in Excel and have Excel find the duplicates.

To avoid duplicates in the future, make sure you have the 'Unique' checkbox ticked on the relevant attribute.

Best regards,

Kris

[Risikanta Pradhan]

Hi @Kris Dewachter ,

Thanks for the reply.

So, if I checked the checkbox in host then this asset will update or not whenever the discovery import is running and some assets will come in the object schema. 

Regards

Risikanta

[Kris Dewachter]

Hi @Risikanta Pradhan ,

Yes, when an attribute is marked as 'unique', the import will fail on this item.

You will probably have to cleanup your duplicate objects first, before you are able to set this 'unique' indicator.

Best regards,

Kris

[Risikanta Pradhan]

Hi @Kris Dewachter 

Thanks for the reply.

So, the assets will not be update if I marked as 'unique'.

Regards

Risikanta

[Kris Dewachter]

It will not update your existing objects

[Risikanta Pradhan]

Hi @Kris Dewachter 

But I want a solution which is helping me for remove duplicates and update the existing one and there will not create any duplicates.

Please help me for solving these problems.

Regards

Risikanta

[Kris Dewachter]

Hi @Risikanta Pradhan ,

This are the steps you need to take:

1. Identify the duplicates via an export (see my first reply)

2. Remove the duplicates

3. Set the attribute to 'unique' so no more duplicates can be created

Best regards,

Kris

[Risikanta Pradhan]

Hi @Kris Dewachter 

Thank you for this answer.

But I would like to know one solution where the object schema will do not create any duplicates assets with the assets will update.

Thanks 

Risikanta 

[Katarina Puchrikova]

Hi @Risikanta Pradhan

Have you found a solution to updating the assets? I am looking for the same solution.

Thanks,

Katarina

[Risikanta Pradhan]

@Katarina Puchrikova  Yes, I have found that solution

[Katarina Puchrikova]

@Risikanta Pradhan Can you share your solution?

[Risikanta Pradhan]

Hi @Katarina Puchrikova , you need to create another object schema from starting or first you can delete all duplicates, and the name attribute of the host should be unique. Only this way you can prevent duplicate assets.