Highlighted

Asset report

Avatar

Avatar

key-key

Avatar

key-key

key-key

15-01-2019

HI

I a puzzling one!

IN AEM 6.1 how can one print a report for the following;

"Assets which have been published and on a live page for over a year"

Thanks

KJ

Replies

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

15-01-2019

AEM Assets do not contain properties that store this information.

Highlighted

Avatar

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281
Gaurav-Behl
MVP

15-01-2019

try this query in /crx/de.  Modify the date and other fields as required. This would just give the published assets and not the referenced assets - 

select * from [dam:Asset] as node where node.[jcr:content/cq:lastReplicated] > CAST('2017-01-01T00:00:01.000Z' AS DATE) and node.[jcr:content/cq:lastReplicationAction] = 'Activate' and ISDESCENDANTNODE(node, [/content/dam/we-retail])

Now create a join for reference property or otherwise write code using

aem-samples/ReferencedAssetsServlet.java at master · Adobe-Marketing-Cloud/aem-samples · GitHub

AssetReferenceSearch ("The Adobe AEM Quickstart and Web Application.")

SQL2 reference -

http://drfits.com/jcr-sql2-query-with-examples/

9 JCR-SQL2 Queries Every AEM Developer Should Know - Blog - 6D Global

Highlighted

Avatar

Avatar

bsloki

MVP

Total Posts

1.9K

Likes

172

Correct Answer

544

Avatar

bsloki

MVP

Total Posts

1.9K

Likes

172

Correct Answer

544
bsloki
MVP

15-01-2019

This should be custom built but it should be pretty straight forward with the right query based on the properties you would need and objective of the report

Highlighted

Avatar

Avatar

key-key

Avatar

key-key

key-key

22-01-2019

thank you!