How can I create a report on assets with an expiration within 60 days in aem as a cloud?

[ReddyIshanvi]

How can I create a report on assets with an expiration within 60 days and run it daily Monday to Friday. Report should include custom fields as well.

[digarg31 · Accepted solution]

You can check ACS AEM Commons Report builder https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/configuring.html . Let's you create a report based on your custom query and input parameters and you can download it as well.

OOTB asset reports have expiration reports but would not allow you to customize as per 60 days time period req.

E.g : Input Parameter - Root Path - for performance reasons

Time period - 60 days to give more flexibility

SQL Query : Find all dam:asset under a given root path whose expiration date( prism:expirationDate )property is within 60 days range from the current date.