Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

User Activity Report

AnHamilton
Level 1
Level 1

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution
Sandeep6
Correct answer by
Level 5
Level 5
2 Replies
Sandeep6
Correct answer by
Level 5
Level 5
joe_s66
Level 3
Level 3

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