User Activity Report

Avatar

Avatar

AnHamilton

Avatar

AnHamilton

AnHamilton

26-10-2020

I would really like to be able to run a report that will tell me when my users log in and how often they log in. If I could also know what they did (edit, upload asset, publish) that would be awesome. This seems like a report that would be fairly standard for user management. I want to reduce the number of users and knowing this data would be a huge help in determining who should stay.

Report Builder reports User Access

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Avatar

Avatar

joe_s66

Avatar

joe_s66

joe_s66

27-10-2020

I used the information based on the following blog to create a ACS AEM report to generate this type of report. After adding the profile/lastloggedin property, here's the query that I use in the configuration:

SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users/]) AND [profile/familyName] is not null AND [profile/givenName] is not null AND [profile/email] is not null ORDER BY {{order}} 

https://www.albinsblog.com/2020/09/adobe-experience-manager-reporting-on-users-last-login-date.html#...

 

flow-chart.png