Asset Report Generation | Community
Skip to main content
V
VJain03
Level 2
February 27, 2024
Solved

Asset Report Generation

  • February 27, 2024
  • 3 replies
  • 1747 views

Hello,

Currenty we have using AEMAACS and in that AEM DAM has around 90k assets and few sub folders has around 28k to 40k assets we need to generate an Asset report and in that dam:sha1 value need to be included.

In AEM OOTB Asset Report we are not able to add dam:sha1 value.
Using servlet we have written the code but its taking too much time and some times time out error. 

Is there any other way that we can add dam:sha1 value in our asset report using AEM OOTB Asset Reports or using ACS Commons package.

please help me solve the requirement.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Adilos-Cantuerk

(edit: forgot to mention you and i am not sure if you get a notification if i do not @vjain03  you)

There are many properties that do not show up when you click the "open selection dialoge" button.
Just write the name of the property. name the column as you want and write in the value:
/jcr:content/metadata/dam:sha1
in the "Property to map" field then proceed and the report will contain the value.

 

3 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity Advisor
Community Advisor
February 28, 2024

@vjain03 I have written a simple query to read the dam:sha1 property of an asset, it brings the assets with that property. If your query gets time out or traversal error, please check the property exists in index. 

 

path=/content/dam/pathtoassetfolder
p.limit=-1
property=jcr:content/metadata/dam:sha1
property.operation=exists
p.hits=selective
p.properties=jcr:content/metadata/dam:sha1

    V
    VJain03Author
    Level 2
    February 28, 2024

    Thanks for the reply @saravanan_dharmaraj but we want it to happen in AEM OOTB Assect Report if possible

      D
      Adobe Employee
      digarg17Adobe Employee
      Adobe Employee
      February 28, 2024

      You can use report builder under ACS AEM Commons to include any metadata property in result columns. All reports are downloadable as csv. You can easily create your custom reports https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

        Adilos-Cantuerk
        Community Advisor
        Adilos-CantuerkCommunity Advisor
        Community Advisor
        February 28, 2024

        Sorry - big edit:
        @vjain03 wouldn't it be possible to add
        jcr:content/metadata/dam:sha1
        to your report as a custom metadata?

        I know it its possible to create a csv export using that value - and it is possible to merge two csv files based on AssetPath column.

          V
          VJain03Author
          Level 2
          February 29, 2024

          Thanks for the reply @adilos-cantuerk, but dam:sha1 property is not present if we add through custom coulmn addition using AEM OOTB Report  

            Adilos-Cantuerk
            Community Advisor
            Adilos-CantuerkCommunity AdvisorAccepted solution
            Community Advisor
            February 29, 2024

            (edit: forgot to mention you and i am not sure if you get a notification if i do not @vjain03  you)

            There are many properties that do not show up when you click the "open selection dialoge" button.
            Just write the name of the property. name the column as you want and write in the value:
            /jcr:content/metadata/dam:sha1
            in the "Property to map" field then proceed and the report will contain the value.

             

              kautuk_sahni
              Community Manager
              kautuk_sahniCommunity Manager
              Community Manager
              February 28, 2024

              @vjain03 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

              Kautuk Sahni
              Terms & ConditionsAccessibility statement

              Loading footer...