User Activity Report | Community
Skip to main content
October 26, 2020
Solved

User Activity Report

  • October 26, 2020
  • 2 replies
  • 1253 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sandeep6

Hi @anhamilton ,

 

Please follow below article.

 

https://helpx.adobe.com/experience-manager/6-3/sites/administering/using/reporting.html#UserReport 

 

Thanks,

Sandeep. 

2 replies

Sandeep6Accepted solution
Level 4
October 27, 2020
joe_s66
Level 3
October 27, 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#.X474nxKSmUk