User Report Export | Community
Skip to main content
August 9, 2018
Solved

User Report Export

  • August 9, 2018
  • 4 replies
  • 2830 views

Hello,

I have been attempting to export information on our users with no avail from AEM 6.1. Essentially, I would like to export a report in .CSV or a similar format that provides a list of our total users, when they last accessed the system and finally, the roles or permissions that they have been associated with the users in the system.

Is this something that can be achieved with AEM 6.1?

Best,

Emmanuel

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 Jitendra_S_Toma

Hi,

There are a lot of inline editable Javascript based tools or model. You can use any of those. Mostly they need JSON object as input.

ExtJS is one of those.

I hope this helps.

4 replies

Jitendra_S_Toma
August 9, 2018

Hi,

AEM does provide reporting on page access & user reports with very limited features. However, For your requirement, it seems you need to build a custom solution.

Getting user information would not be hard for you but getting the permission of a particular user is very subjective. Any user can have many access at different levels in the AEM Repository. You need to define when you are generating a report for permissions.

Find a role could be easy though.

User Reporting reference

Reporting

August 9, 2018

Thank you for your response, I was able to build the report on the users. however, I am having a hard time exporting the information to an editable format. Would you have any ideas on how to accomplish this?

smacdonald2008
August 9, 2018

Build a custom service that dumps the data into EXCEL - see Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager

This is an older community article - we will update this to a new AEM version.

Jitendra_S_Toma
Jitendra_S_TomaAccepted solution
August 9, 2018

Hi,

There are a lot of inline editable Javascript based tools or model. You can use any of those. Mostly they need JSON object as input.

ExtJS is one of those.

I hope this helps.