Generate DAM Folder Structure report / Folder Structure Data into CSV

[cxasha]

Hello!

Could you tell me if there are any scripts or AEM tools which can generate entire DAM folder structure into an Excel/CSV?

[DPrakashRaj · Accepted solution]

https://experienceleague.adobe.com/docs/experience-manager-learn/assets/advanced/asset-reports.html?....

[bharath_kumark]

Hi @cxasha,

If you have the ACS Commons package installed on your instance, you can use the ACS Commons reports feature to get the Assets Hierarchy report as mentioned below.

Steps:

1. Click on Tools -> ACS AEM Commons -> Reports
2. Add Report by giving user friendly title "Assets Hierarchy"
3. Open the newly created Assets Hierarchy report.
4. Add configuration by selecting "JCR Query Report Configuration" in Configuration section.
5. Add search parameters path for selection using "ACS Commons Report Builder Basic Parameter".
6. Add results column for path to be print on it using "ACS Commons Report Builder Path Column".

JCR Query Report Configuration:

1. Query -> SELECT * FROM [sling:Folder] AS s WHERE ISDESCENDANTNODE([{{path}}]) ORDER BY {{order}}
2. Query Language -> JCR SQL2
3. Page Size -> <based on your requirements>

ACS Commons Report Builder Basic Configuration: [Path]

1. Label -> Path
2. Name -> path
3. Required -> true
4. Field Type -> Text Field

ACS Commons Report Builder Basic Configuration: [Order]

1. Label -> Order
2. Name -> order
3. Options [Key : Value]
   1. Default : SCORE()
   2. Title (A-Z) : [jcr:content/jcr:title] ASC
   3. Title (Z-A) : [jcr:content/jcr:title] DESC
   4. Last Modified : [jcr:content/cq:lastModified] DESC
   5. Oldest : [jcr:content/cq:lastModified] ASC

ACS Commons Report Builder Path Column: [Path]

1. Heading -> Path
2. Include Link -> true

ACS Commons Report Builder Replication Status Column: [Replication Status]

1. Heading -> Replication Status

Sample Report:

Please let me know if this helps.

Thanks!

[Nilesh_Mali]

Report suggested by @DPrakashRaj gives all the DAM report in CSV/excel.

Thank you !!