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

How to get user list in AEM

Avatar

Avatar
Validate 1
Level 2
surendarm613658
Level 2

Likes

6 likes

Total Posts

33 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
surendarm613658
Level 2

Likes

6 likes

Total Posts

33 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
surendarm613658
Level 2

21-01-2019

HI,

I am trying to pull list of members under "intranet-authors" group using query debugger in AEM 6.3.

below is the crxde page.

In below screenshot - in rep:memebrs properties only ID for users are given.. When is select the ID then it goes the corresponding user name.

Please suggest the query to get the name of users

1672667_pastedImage_1.png

Used below query to get the info but i am getting only path results.

p.hits=selective

p.limit=-1

p.properties=jcr:uuid

path=/home/groups/intranet/intranet-authors/

type=rep:users

p.properties=jcr:path

1672668_pastedImage_2.png

Replies

Avatar

Avatar
Validate 50
Level 6
cquser1
Level 6

Likes

75 likes

Total Posts

313 posts

Correct Reply

15 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Give Back 50
View profile

Avatar
Validate 50
Level 6
cquser1
Level 6

Likes

75 likes

Total Posts

313 posts

Correct Reply

15 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Give Back 50
View profile
cquser1
Level 6

21-01-2019

Avatar

Avatar
Validate 50
Level 6
cquser1
Level 6

Likes

75 likes

Total Posts

313 posts

Correct Reply

15 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Give Back 50
View profile

Avatar
Validate 50
Level 6
cquser1
Level 6

Likes

75 likes

Total Posts

313 posts

Correct Reply

15 solutions
Top badges earned
Validate 50
Validate 25
Validate 10
Validate 1
Give Back 50
View profile
cquser1
Level 6

21-01-2019

Avatar

Avatar
Validate 1
Level 2
surendarm613658
Level 2

Likes

6 likes

Total Posts

33 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
surendarm613658
Level 2

Likes

6 likes

Total Posts

33 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
surendarm613658
Level 2

21-01-2019

Hi  - Thanks for sharing the link. To be frank i have already reviewed the links before posting the note but that doesn't give the exact query to get the user list. As mentioned in links - our environment is not suitable to get information through user admin console. Please suggest a exact query that pulls the member list in AEM? I believe that is really possible through query debugger

Avatar

Avatar
Ignite 5
Level 6
AnkurAhlawat
Level 6

Likes

111 likes

Total Posts

165 posts

Correct Reply

27 solutions
Top badges earned
Ignite 5
Ignite 3
Ignite 20
Ignite 10
Ignite 1
View profile

Avatar
Ignite 5
Level 6
AnkurAhlawat
Level 6

Likes

111 likes

Total Posts

165 posts

Correct Reply

27 solutions
Top badges earned
Ignite 5
Ignite 3
Ignite 20
Ignite 10
Ignite 1
View profile
AnkurAhlawat
Level 6

22-01-2019

It is not adviced to make a query to fetch user list, as a group might contain uuid of another group as rep:member which in turns contains another group. It is not possible to fetch it using single query in query builder.

I would rather advice if possible please use group interface api and call below method to get list of members.

Iterator<Authorizable>getMembers()

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,089 likes

Total Posts

3,123 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,089 likes

Total Posts

3,123 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

22-01-2019

I recommend to try the "Users to CSV Exporter" of ACS AEM Commons [1] instead of doing it yourself 🙂

Jörg

[1] Exporters