User and group report | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SureshDhulipudi
SureshDhulipudiAccepted solution
New Participant
Oct 28, 2020 10:45 AM UTC

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

View reply

5 replies

santhosh_kumark
santhosh_kumark
Level 6
Oct 28, 2020 3:30 PM UTC

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-and-users-permission-details-to-excel/qaq-p/384259/comment-id/81979#M81979

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.

 

  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

Translate
    SureshDhulipudi
    SureshDhulipudiAccepted solution
    New Participant
    Oct 28, 2020 10:45 AM UTC

    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

    Translate
      BrijeshYadav
      BrijeshYadav
      Level 5
      Oct 28, 2020 10:16 AM UTC

      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

       

      Translate
        anands11413462
        New Participant
        Apr 12, 2022 1:35 PM UTC

        Brijesh Sir,

         

        I recently developed a Groovy scripts that can fetch a User data based on Its' group. Also built the AEM component for the same.

         

        Regards

        Anand Shekhar 

        Translate
          anands11413462
          New Participant
          Apr 12, 2022 2:45 PM UTC

          mport org.apache.jackrabbit.api.security.user.UserManager;
          import org.apache.jackrabbit.api.security.user.UserManager;
          import java.util.Iterator;
          import org.apache.jackrabbit.api.security.user.User;
          import org.apache.jackrabbit.api.security.user.Authorizable;
          import org.apache.jackrabbit.api.security.user.Group;

          def resourceResolverFactory = getService("org.apache.sling.api.resource.ResourceResolverFactory")
          def resourceResolver = resourceResolverFactory.getAdministrativeResourceResolver(null);
          UserManager userManager = resourceResolver.adaptTo(UserManager.class);

          def authorizable= userManager.getAuthorizable("<<Group-Name>>");
          Group group = (org.apache.jackrabbit.api.security.user.Group) authorizable;

          Node node = resourceResolver.adaptTo(Node.class);
          int count = 1;
          Iterator itr = group.getMembers();

          if (itr.hasNext()){

           println 'hello'
           
           
           while(itr.hasNext()) {
                          String valText="";
                          Object obj = itr.next();
                            if(obj instanceof User) {
                                  User user = (User) obj;
          node = resourceResolver.getResource(user.getPath()).adaptTo(Node.class);
          String nodePathStr = user.getPath().toString();

                                 if (node.hasProperty("jcr:primaryType")){
          String val_primaryType = node.getProperty("jcr:primaryType").getString();
                                      if(val_primaryType.equals("rep:User")){

                                                  if(node.hasProperty("rep:principalName")){
                                                      valText=node.getProperty("rep:principalName").getString();
                                                  }
                                                  if(node.hasNode("profile")){
                                                     if(node.hasProperty("./profile/familyName")){
                                                       valText="User ID : "+valText+",... Last Name : "+node.getProperty("./profile/familyName").getString();
                                                         }
                                                  if(node.hasProperty("./profile/givenName")){
                                                        valText=valText+",... First Name : "+node.getProperty("./profile/givenName").getString();
                                                        }
                                                      if(node.hasProperty("./profile/email")){
                                                        valText=valText+",... Email  : "+node.getProperty("./profile/email").getString();
                                                        }
                                                      if(nodePathStr!=null){
                                                          valText =valText+"... Node Path : "+nodePathStr;
                                                      }
                                                  }
                                      }  
                                      println count +" " +valText;
                                          count++;

                                  }
                            }
                      }
           
           
           
          }

          Translate
            Terms & ConditionsAccessibility statement

            Loading footer...