Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Risikanta Pradhan
Contributor
June 18, 2023

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. 

1 answer

1 vote
Kris Dewachter
Community Champion
June 19, 2023

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
Contributor
June 19, 2023

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
Community Champion
June 19, 2023

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
Contributor
June 19, 2023

Hi @Kris Dewachter 

Thanks for the reply.

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

 

Regards

Risikanta

Kris Dewachter
Community Champion
June 20, 2023

It will not update your existing objects

Risikanta Pradhan
Contributor
June 20, 2023

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
Community Champion
June 20, 2023

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
Contributor
June 29, 2023

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 February 5, 2024

Hi @Risikanta Pradhan

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

Thanks,

Katarina

Risikanta Pradhan
Contributor
March 18, 2024

@Katarina Puchrikova  Yes, I have found that solution

 

 

Katarina Puchrikova March 18, 2024

@Risikanta Pradhan Can you share your solution?

Risikanta Pradhan
Contributor
March 18, 2024

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. 

Chatar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 18, 2025

Hi folks,

@Katarina Puchrikova @Risikanta Pradhan  @Kris Dewachter 

as this is a problem a lot of people have with managing the assets easily we created an app which solves the asset duplicates case. You can find it here:

 https://marketplace.atlassian.com/apps/1235771/asset-duplicates-manager-for-jira?hosting=cloud&tab=overview

Cheers
Reda

Risikanta Pradhan
Contributor
August 18, 2025

Hi @Chatar

Thank you for sharing the new application link. I really appreciate it

 

Regards,

Risikanta

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events