How to find all duplicate assets in AEM dam?

I need to find all the duplicated assets in DAM.

I followed https://docs.adobe.com/docs/en/aem/6-2/author/assets/managing-assets-touch-ui/duplicate-detection.html

This document is not helping me in searching for all duplicate values. Also, it doesn't tell that i am uploading a duplicate asset. It just pops-up a window asking for replacing or create new version for that asset.

My priority is to get list of all duplicated DAM assets. Please advise

Thanks in advance. enter image description here

AFAIK when you enable the detect duplicate, The behavior will be in the following way.

Touch UI : when you try to upload and then try to Create Version/Replace the asset which is already present. It will populate a popup notating same. Classic UI : It will end up throwing an error with out asking such as Touch UI popup as shown below. I guess Adobe has concentrated only on the Touch UI implementation.

When you upload the asset to aem it will create a lot properties for the DAM Assets, one of the property is dam:sha1, The detect duplicate logic will work based on this property value data.

And to get the list of duplicate assets paths you can use a XPATH query

//element(*, dam:Asset)[(jcr:content/metadata/@dam:sha1 = 'ff546dd8055fcfca53471dfa6fe0494c4198e965')]

Where in the "ff546dd8055fcfca53471dfa6fe0494c4198e965" value is of my image dam:sha1 property value. find the below screenshot for reference.