Hi,
I would say the best answer depends what your use case is, and so what kind of output is fit to purpose
Zero cost option is to do an excel export of a metaclass and the attributes you want to look at and then use MS excel features around duplicates (e.g. Conditional formatting > highlight cells values rules > duplicate values)
-> if you look for duplicates, you probably want to resolve them by renaming, you can modify in excel and import back (while in excel you may also want to use additional text manipulation functions or data analysis plug in ; there is probably a lot that can be done without breaking the format and keeping the option to reimport the data cleansing result)
note : merging duplicates which are actually the same object is best performed in Hopex directly or via script
ERQL itself will have limited capabilities in terms of counting / looping on various inputs, but surely this can be handy as part of a report or a script to perform more advanced things without having to reimplement everything in the script (most of the times you would look for typos or close names but not exact duplicates)
https://doc.mega.com/hopex-v6-en/#page/MTS2/Customizing_Metamodel/query_syntax.List_of_Query_Operato...,
for instance :
Select Application where [Short Name] like "Appli 0001"
-> will find the objects with the same name / beginning by the same string
Select Application where [Short Name] nearmatch "Appli 0001"
-> will find the objects with close names (e.g. at distance 1 or 2, like "Appli 0002" or "Appli 0011")
using # or ! wildcards you can do more specific things :
Select Application where [Short Name] like "Appli #1"
Select Application where [Short Name] like "Appli !0!!"
