Generate a report of all the assets that have been modified using smartCrop

[H_Malhotra]

Hi All,

I'm currently in the planning stage of migrating from AMS to AEMaaCS. Due to a lot of corrupt metadata in our system, it has been suggested that before migration we create a new Dynamic Media account with Adobe and process the assets with that account. However, it was highlighted by the Adobe team that any customization on the assets done using smartCrop will be lost in this process. 
In light of this information, I want to generate a report of all the assets in our system that have been modified using the smartCrop functionality. 
Since the cropping information is not stored as separate rendition nodes in the CRX repository, I am unable to query that data. 

Can anyone guide me in the right direction to acheive this?

Thank you!
Harshita Malhotra

[giuseppebag]

hi @H_Malhotra,
When the SmartCrop feature is used, it stores properties named SmartCrop**, such as SmartCropRect or SmartCropDef (as you can see for example here). You can use one of these properties to query the repository, for example:

SELECT * FROM [dam:Asset] AS a 
WHERE ISDESCENDANTNODE(a, '/content/dam') 
AND a.[dam:smartCropDef] IS NOT NULL

You can execute this through:

• CRXDE Lite's Query tool

• QueryBuilder with appropriate parameters

• A custom servlet that processes the results

[Tethich]

Hi @H_Malhotra 

Do you mean that you have tried to use AEM report functionality by adding custom property path pointing to smartcrops properties ?

https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/assets/admin/ass...