Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Risikanta Pradhan 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 20, 2023

It will not update your existing objects

Risikanta Pradhan 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 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 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 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. 

Suggest an answer

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

Atlassian Community Events