How to get user list in AEM

[surendarm613658]

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

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

[cquser1]

Hi,

can i retrieve the users list and along with their group names in query builder? might help.

[cquser1]

CQ5 CMS Blog | Adobe Experience Manager blog : How to get users members of a group in cq5 has some similar details.

[surendarm613658]

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

[AnkurAhlawat]

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()

[Jörg_Hoh]

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

Jörg

[1] Exporters