AEM 6.4 Reports - Collections

Avatar

Avatar

Gl369

Avatar

Gl369

Gl369

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

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

21-08-2018

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

Answers (7)

Answers (7)

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

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

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

21-08-2018

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

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

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

Gl369

Avatar

Gl369

Gl369

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

kautuk_sahni

Community Manager

Total Posts

5.8K

Likes

1.0K

Correct Reply

1.1K

Avatar

kautuk_sahni

Community Manager

Total Posts

5.8K

Likes

1.0K

Correct Reply

1.1K
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

Gl369

Avatar

Gl369

Gl369

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

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

17-08-2018