Expand my Community achievements bar.

Join expert-led, customer-led sessions on Adobe Experience Manager Assets on August 20th at our Skill Exchange.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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.