Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Asset report

Avatar

Avatar
Validate 10
Level 3
key-key
Level 3

Likes

18 likes

Total Posts

73 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
key-key
Level 3

Likes

18 likes

Total Posts

73 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
key-key
Level 3

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
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,408 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,408 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

15-01-2019

AEM Assets do not contain properties that store this information.

Avatar

Avatar
Establish
MVP
Gaurav-Behl
MVP

Likes

248 likes

Total Posts

1,147 posts

Correct Reply

283 solutions
Top badges earned
Establish
Give back 300
Give Back 50
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
Gaurav-Behl
MVP

Likes

248 likes

Total Posts

1,147 posts

Correct Reply

283 solutions
Top badges earned
Establish
Give back 300
Give Back 50
Give Back 5
Give Back 3
View profile
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
Validate 25
MVP
bsloki
MVP

Likes

182 likes

Total Posts

1,859 posts

Correct Reply

545 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 50
Boost 5
View profile

Avatar
Validate 25
MVP
bsloki
MVP

Likes

182 likes

Total Posts

1,859 posts

Correct Reply

545 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 50
Boost 5
View profile
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
Validate 10
Level 3
key-key
Level 3

Likes

18 likes

Total Posts

73 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
key-key
Level 3

Likes

18 likes

Total Posts

73 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
key-key
Level 3

22-01-2019

thank you!