Determining public/published and private assets from a CSV export

[joy2020]

I have used the metadata export function in my DAM (AEM 6.4). Are there fields within an export which allow me to determine which asset paths are public (as opposed to a private or unpublished asset)?

I'm able to do this within the AEM UI but it would be more scalable to do so within the spreadsheet exported. 

Thank you. 

[FreedomMarketin · Accepted solution]

This information should be in your metadata export.  Don't have ready access to 6.4 instance at moment, but I believe the answer is the same on 6.5.

I think the problem is that the some of replication metadata is not on the metadata node, so it isn't included in your CSV.

Not sure if you what replication queues you have configured. Portal and Sites replication information will be at the jcr:content node rather than the jcr:content/metadata node. If you have Dynamic Media connected, this information is available at the metadata node and will show in a metadata export CSV. 

In 6.5, the metadata property you should look for in your CSV is dam:scene7FileStatus{{String}}.   Values of PublishComplete indicate an asset is published to Dynamic Media.

By the way, if this need is worth the development customization, you could customize your publish workflow to set a custom metadata field on the metadata node so all publishing information was available via this route.  

Hope this helps,

Beau

[Phani2]

AEM users can also utilize the Assets Reporting functionality to create and later request reports showing the expiration status and/or date for each asset. To access the Assets Reports page users need to open the Tools Panel and then Assets -> Assets Report. The Assets Expired item in the right-side bar is available by default. After selecting it user just needs to use Generate Report button at the bottom. A visual report will be generated which can also be exported to CSV. 

Hope this helps !!

For other tools in aem like this can be found in this blog ::

https://kbwebconsult.com/5-ways-aem-assets-simplifies-the-tedious-digital-rights-management/