Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

AEM 6.4 Reports - Collections

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

8 Replies

Avatar

Level 3

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

Administrator

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



Kautuk Sahni

Avatar

Level 3

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

Level 10

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

Level 10

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

Avatar

Correct answer by
Level 10

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

Avatar

Level 10

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