nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Risikanta Pradhan_u99csz

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.

Accepted answers

All comments

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_u99csz

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.