AEM Assets - Reporting on how many files were replaced

[JimPresley]

We would like to know how many "Files" were replaced (new file version) within a specific time period.  Is the needed info available to pull that data?

[ShivamKumar]

Hi Jim,

If you want to fetch some assets which were replaced, you can simply use query builder to fetch those assets for that specific period of time. You just have to put the condition for jcr:last modified.

If you need more info on query builder, please let me know. If this doesn't solve your problem, then please clarify your whole requirement.

[JimPresley]

Thank you, ShivamKumar.  We are doing some re-work on our Web platform to be pulling assets out of AEM Assets.  We want to make sure the latest rendition is pulled.  Part of the discovery on that is the question, "how often are we actually updating assets to new versions".  Presently our AEM assets instance is set to clear cache whenever a new asset is versioned.  That works but we are curious how efficient that may be or not be if we are updating many files and the cache is cleared every time as asset is versioned.   Using "modified" will have every time an asset is modified (new asset, metadata edit) etc. so that query won't give us the correct data.  Basically looking at how many time assets were versioned in a set period (week, month_etc.

Thank you again for your time and assistence!

[JimPresley]

If we could determine how many times Dam Update Asset workflow has run on assets already published to Dynamic Media and DM has created new renditions, that would be good data.

[ShivamKumar · Accepted solution]

To determine how often the Dam Update Asset workflow has run on published assets, you can query the workflow history stored under /var/workflow/instances, filtering for the workflow model like dam/update_asset model and completed status. Then, cross-check the payload paths to confirm if the assets were already published (using cq:lastReplicationAction = Activate). Optionally, inspect rendition timestamps to detect updates.