Hi,
I need to pull a report from AEM extracting a list of assets and filtering by those that are live (active on a published page) so that I can perform some clean up (of data within them) in bulk.
I'm using this tutorial to pull the export, but I can't for the life of me figure out how to filter by only the assets that are live/published. Is there a metadata field that would give me that information?
Hi,
Usually, the assets will possess certain properties on which you could rely, such as cq:lastReplicated and cq:lastReplicationAction. However, it is not guaranteed with 100% certainty that these properties can determine whether assets are published or not. The most straightforward approach would be to generate a report of the existing assets on one of your publish instances. With this information, you can be certain about which assets are published or activated. You can request assistance from your administrator, or if you have access, you can either download a package containing the assets or simply execute the metadata report you referred to.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.