Download asset report

Question

Hi, I'm trying to download asset report in csv file from ACS AEM Commons using query builder but I'm getting an empty excel with no assets. Below I mentioned my query-

type=dam:Asset
path=/content/dam/cognizant-dot-com
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2025-03-01
group.1_daterange.upperBound=2025-03-15
p.limit=1000
p.guessTotal=true
p.indexTag=assetsOmnisearch

giuseppebaglio · Accepted Answer

I believe the issue may lie in the "Result Columns" section. At a minimum, you must add the component "ACS Commons Report Builder Path Column" to view the asset paths. This is my configuration, which is quite simple:

It gives the following result:

Karishma_begumSh · Answer

hi @prachimathur

once try to rewrite the query as below before ACS AEM commons

type=dam:Asset
path=/content/dam/cognizant-dot-com
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2025-03-01T00:00:00.000Z
group.1_daterange.upperBound=2025-03-15T23:59:59.999Z
orderby=@jcr:content/jcr:lastModified
orderby.sort=desc
p.limit=-1

Sign up

Login with SSO

Login to the community

Login with SSO