AEM 6.4 Reports - Collections

[Gl369]

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

[smacdonald2008]

Watch this AEM ATCE - it captures Reporting information - Scott's Digital Community: April 2018: Ask the AEM Community Expert: Easy Access to Critical Informa...

[Gl369]

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. 

[kautuk_sahni]

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

[Gl369]

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).

[smacdonald2008]

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)

[smacdonald2008]

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

[smacdonald2008 · Accepted solution]

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

[smacdonald2008]

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