Report with the list of authors/DAM asset uploaders

[Vani1012]

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

[ShaileshBassi · Accepted solution]

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

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

[aanchal-sikka]

@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

[Gaurav_Sachdeva_]

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