User and group report

Avatar

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ranadyutis95334
Level 3

28-10-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Ignite 1
MVP
SureshDhulipudi
MVP

Likes

163 likes

Total Posts

174 posts

Correct reply

49 solutions
Top badges earned
Ignite 1
Give Back 5
Give Back 3
Give Back 10
Give Back
View profile

Avatar
Ignite 1
MVP
SureshDhulipudi
MVP

Likes

163 likes

Total Posts

174 posts

Correct reply

49 solutions
Top badges earned
Ignite 1
Give Back 5
Give Back 3
Give Back 10
Give Back
View profile
SureshDhulipudi
MVP

28-10-2020

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

Answers (2)

Answers (2)

Avatar

Avatar
Establish
MVP
santhosh_kumark
MVP

Likes

99 likes

Total Posts

111 posts

Correct reply

38 solutions
Top badges earned
Establish
Validate 1
Give Back 3
Give Back
Boost 50
View profile

Avatar
Establish
MVP
santhosh_kumark
MVP

Likes

99 likes

Total Posts

111 posts

Correct reply

38 solutions
Top badges earned
Establish
Validate 1
Give Back 3
Give Back
Boost 50
View profile
santhosh_kumark
MVP

28-10-2020

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

Avatar

Avatar
Springboard
Level 5
BrijeshYadav
Level 5

Likes

59 likes

Total Posts

102 posts

Correct reply

19 solutions
Top badges earned
Springboard
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Springboard
Level 5
BrijeshYadav
Level 5

Likes

59 likes

Total Posts

102 posts

Correct reply

19 solutions
Top badges earned
Springboard
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
BrijeshYadav
Level 5

28-10-2020

AEM doesn't have such an inbuilt utility to extract user's information.

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