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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

User and group report

ranadyutis95334
Level 4
Level 4

Hi I need a extract of all the users in a particular group in AEM. Please assist.

User groups
1 Accepted Solution
SureshDhulipudi
Correct answer by
Community Advisor
Community Advisor

If you install ACS Commons, It is providing a report generator - users-to-csv-exporter.html

 

https://localhost:4502/etc/acs-commons/exporters/users-to-csv-exporter.html

once you download the excel, you can filter based on the group name

AEM-User-Report.png

View solution in original post

3 Replies
SureshDhulipudi
Correct answer by
Community Advisor
Community Advisor

If you install ACS Commons, It is providing a report generator - users-to-csv-exporter.html

 

https://localhost:4502/etc/acs-commons/exporters/users-to-csv-exporter.html

once you download the excel, you can filter based on the group name

AEM-User-Report.png

View solution in original post

santhosh_kumark
Community Advisor
Community Advisor

Hi @ranadyutis95334  ,

 

Have you tried ACS User Exporter?

Link: https://adobe-consulting-services.github.io/acs-aem-commons/features/exporters/users/index.html 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-import-aem-groups-a...

Navigate to http://localhost:4502/miscadmin#/etc/acs-commons/exporters and create a new Users to CSV Export page.

Name the page appropriately as the page’s report configuration can be saved and run again later.

santhosh_kumark_1-1603898965016.png

 

  1. Define any custom properties to add to the report. These are relative property paths off the user node ([rep:User])
    • Examples: profile/middleName, preferences/somePref
  2. Group Membership type:
    • Direct: Only include users who are have been explicitly added to a group selected below.
    • Indirect: Only include users who are members through group inheritance of a group selected below.
    • Direct and Indirect: Any group membership.
  3. Groups:
    • Select any number of groups that will be used to filter in users to the report by the group membership type selected above.
  4. Optionally, click Save Configuration at the top to save this configuration to this page. Multiple User to CSV Exporter pages with different configurations can be created.

  5. Click Download User CSV Report to download the CSV Report of the user for easy import into Excel.

 

Regards,

Santosh