Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
SOLVED

Generate DAM Folder Structure report / Folder Structure Data into CSV

Avatar

Level 2

Hello!

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
3 Replies

Avatar

Correct answer by
Community Advisor

Avatar

Level 2

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:

bharath_kumark_0-1702015718485.png

 

Please let me know if this helps.

 

Thanks!

Avatar

Level 3

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

Thank you !!