Download asset report

[prachimathur]

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

[giuseppebag · Accepted solution]

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:

[prachimathur]

This is working. Thanku

[Karishma_begumSh]

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