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

AEM 6.4 Reports - Collections

Avatar

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Gl369
Level 2

17-08-2018

Is there a way to create a report on Collections?  I do not see the location or folder when I use create > files

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

21-08-2018

Team confirmed (what we thought) no OOTB for this. We are discussing next best options.

Answers (7)

Answers (7)

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

22-08-2018

Another team reply --

>>As a test, I tried to point Asset Reports>Files to /content/dam/collections

For starters we send the query to look for dam:Asset type of nodes only [0], in its place we would need to send the following predicates to look up collections –

  1. group.0_property: sling:resourceType
  2. group.0_property.1_value: dam/smartcollection
  3. group.0_property.0_value: dam/collection
  4. group.1_property: sling:resourceSuperType
  5. group.1_property.value: sling/collection

type:nt:unstructured

However it will take more modifications in code since the reports was created to handle only assets

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

21-08-2018

We are checking with the Asset AEM team to see the best options here.

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

21-08-2018

When a collection is created, i am wondering if you can use the JCR EVENT API to track these events and then start creating your reports based on these events. But this will not work - as in the DOCS  - it states:

You can share multiple collections with a user. Each collection contains references to assets. The referential integrity of assets is maintained across collections.

Collections are of the following types, based on the way they collate assets:

  • A collection that contains a static reference list of assets, folders, and other collections
  • A Smart collection that dynamically includes assets based on a search criteria

So nodes are not added into a collection (therefore no JCR Event is fired)

Avatar

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Gl369
Level 2

21-08-2018

I need a collections report similar to many of the Asset Reports (on 6.4.1) such as files or uploads.  As a test, I tried to point Asset Reports>Files to /content/dam/collections.  While the request was successful, the report was empty and suspect the issue is the way collections are actually stored (are they just references?).

I am looking to know how many collections, who created, who downloads/accesses, total number of assets, date last accessed/modified, etc.,  Ultimately, our objective is to have a process in place to manage the collections, including removing/deleting as we are a multi-tenant install and have over 400 collections (growing at +10 a day).

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,127 likes

Total Posts

6,121 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,127 likes

Total Posts

6,121 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

21-08-2018

What sort of report are you looking on the Collections? Can you help me explain it in a bit?

But just an FYI, we can always run a workflow for the assets within a collection. If the collection contains nested collections, the workflow also runs on the assets within the nested collections. However, if the collection and the nested collection contain duplicate assets, the workflow only runs once for such assets. We can use it to generate our custom reports.

-Kautuk

Avatar

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Gl369
Level 2

Likes

5 likes

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Gl369
Level 2

18-08-2018

Thanks smacdonald2008​​  This is very helpful, but unfortunately above my skills.  One area of particular interest in the webinar was the "Author Activity" which isn't part of the core install.  Any chance Dan or someone can share the settings so we can recreate?  As for the collections question I will keep looking!   One of my challenges is that we are an "Assets Only" implementation and some of the guides and webinars focus on the Sites user. 

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

17-08-2018