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

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K
smacdonald2008

15-01-2019

AEM Assets do not contain properties that store this information.

Avatar

Avatar

Gaurav-Behl

MVP

Avatar

Gaurav-Behl

MVP

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

Avatar

Avatar

bsloki

MVP

Avatar

bsloki

MVP

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

Avatar

Avatar

key-key

Avatar

key-key

key-key

22-01-2019

thank you!