How to get user list in AEM | Community
Skip to main content
surendarm613658
Level 3
Jan 21, 2019 8:08 AM UTC

How to get user list in AEM

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

    5 replies

    joerghoh
    joerghoh
    Employee
    Jan 22, 2019 9:04 PM UTC

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

    Jörg

    [1] Exporters

    Translate
      AnkurAhlawat-1
      AnkurAhlawat-1
      Level 6
      Jan 22, 2019 1:24 PM UTC

      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()
      Translate
        cquser1
        cquser1
        Level 7
        Jan 21, 2019 9:43 AM UTC

        Hi,

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

        Translate
          cquser1
          cquser1
          Level 7
          Jan 21, 2019 9:53 AM UTC

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

          Translate
            surendarm613658Author
            Level 3
            Jan 22, 2019 4:53 AM UTC

            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

            Translate
              Terms & ConditionsAccessibility statement

              Loading footer...