1 Reply Latest reply on Apr 12, 2018 4:42 PM by Okechukwu Ossai

    List of All User group Users who are not part of Other AD groups

    sudhakar reddy

      Hello ALL,

       

      I've a requirement . I need a list of Users from All user groups who are not part of AD groups.

       

      All User Group Users : 7000
      Other AD group Users : 5030

       

      I need the other users who are not part of AD groups but part of all users group.

       

      Regards,

      Sudhakar Reddy

        • 1. Re: List of All User group Users who are not part of Other AD groups
          Okechukwu Ossai

          I assume both lists are different data sources. If yes, then do a LEFT JOIN on User ID or Username. So, 'All User Group' data source should be on the left and 'Other AD group' data source should be on the right of your LEFT JOIN.

           

          This join will keep all users from 'All User Group' but will only bring in matching users from 'Other AD group'.  All users who are not part of AD groups will appear as null.

          Let's assume Username1 is from All User Group table while Username2 is from Other AD group.

           

          Create this calculated field [Users not in AD Group]

          IF ISNULL([Username2] THEN [Username1] END

           

          Hope this helps.

          Regards,

          Ossai