Expand my Community achievements bar.

SOLVED

Report with the list of authors/DAM asset uploaders

Avatar

Level 8

Hi,

Would it be possible for us to get a list of all people in ITBA who can publish or post something on AEM. We would need a list of people with DAM access. We do not need all people who have access, just people who have created or edited pages or uploaded assets.

 

Can anyone help me

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Vani1012 

For the question - We would need a list of people with DAM access.

It totally depends on the way the user permission model is setup as the permissions can be granted to the granual level as well as the parent level.

i.e. the Dam permission can be granted at /content/dam or the folders within it /content/dam/<project-name>. 

Depending on the way it is implemented you can created one custom servlet which check for the acl nodes and create a list and return it.

 

Another way could be that the users are part of the group "dam-users". If that is the case you can directly check the user after navigating to the path 

https://<host>:<port>/ui#/aem/libs/granite/security/content/v2/groupeditor.html/home/groups/d/<group...

Shailesh_Bassi__0-1698985779246.png

 

Other question - people who have created or edited pages or uploaded assets.

For this the only way I could think is create the custom logic to iterate the paths and read the properties and create the list/map for the people belong to the key i.e. created/uploaded or edited based on the properties i.e. jcr:createdBy, cq:lastModifiedBy respectively.

 

Thanks,

Shailesh

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi @Vani1012 

For the question - We would need a list of people with DAM access.

It totally depends on the way the user permission model is setup as the permissions can be granted to the granual level as well as the parent level.

i.e. the Dam permission can be granted at /content/dam or the folders within it /content/dam/<project-name>. 

Depending on the way it is implemented you can created one custom servlet which check for the acl nodes and create a list and return it.

 

Another way could be that the users are part of the group "dam-users". If that is the case you can directly check the user after navigating to the path 

https://<host>:<port>/ui#/aem/libs/granite/security/content/v2/groupeditor.html/home/groups/d/<group...

Shailesh_Bassi__0-1698985779246.png

 

Other question - people who have created or edited pages or uploaded assets.

For this the only way I could think is create the custom logic to iterate the paths and read the properties and create the list/map for the people belong to the key i.e. created/uploaded or edited based on the properties i.e. jcr:createdBy, cq:lastModifiedBy respectively.

 

Thanks,

Shailesh

 

Avatar

Community Advisor

@Vani1012 

 

I am assuming that all users would be defined to specific groups. Thus, DAM users can be identified by the groups.

To generate a report based on groups, you can use  "User Exporter" by ACS commons

https://adobe-consulting-services.github.io/acs-aem-commons/features/exporters/users/index.html


Aanchal Sikka

Avatar

Level 4

Hi @Vani1012 

to get list of authors who have  created or edited pages or uploaded assets you can create query and search for selective properties.

 

path=/content/projectfolder
type=cq:PageContent
nodename=jcr:content
p.hits=selective
p.properties=cq:lastModifiedBy
p.limit=-1 

 

you can get json response when you hit http://localhost:4502/bin/querybuilder.json?path=/content&type=cq:PageContent&nodename=jcr:content&p...

 

you can retrieve all the data from this json.

Hope this helps!

Thanks