Query to get list of assets uploaded today

[ReddyIshanvi]

I have requirement to run a report daily  that provides details of all the assets uploaded that day (the day the report is created) with who uploaded the assets and missing metadata . what is the query i can use to get the list of assets which are uploaded/created the day report is generated?

[Ravi_Pampana · Accepted solution]

Hi

Below is the query to fetch the assets which are uploaded in last 1 day

path=/content/dam/en
type=dam:Asset
relativedaterange.property=jcr:created
relativedaterange.lowerBound=-1d
p.limit=-1

[ReddyIshanvi]

Thank you @Ravi_Pampana