Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

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.