List of Security Groups for an AD User

April 2020’s free Microsoft Endpoint Manager Configuration Manager (ConfigMgr/SCCM/MEMCM) giveaway is the List of Security Groups for an AD User report. This report is available in both Power BI and SSRS formats.

List of Security Groups for an AD User Button

Why do you need this report? Keep reading below!


There are numerous variables to consider when troubleshooting why a user got an application they shouldn’t have, or why they aren’t getting the one app they really need.

Configuration Manager administrators must troubleshoot all possibilities starting first with making sure that deployments are setup correctly and then checking the membership of each collection. When searching through Active Directory (AD) security groups, it might not be easy to tell if a user belongs to a group or not, especially if your organization uses nested security groups. If you have nested security groups, your problem is now a lot more complex.

Fortunately, you can leverage Active Directory User Discovery, Active Directory System Discovery and Active Directory Security Group Discovery in order to see what users and computers belong to a specific AD security group. Unfortunately, there isn’t a built-in report available in Configuration Manager that can put all of this information together and help you determine if a user belongs to a security group or not.

Solution: List of Security Groups for an AD User

Enhansoft’s List of Security Groups for an AD User report leverages the built-in Configuration Manager discovery methods listed above. All in one place, you can see a user’s membership groups in AD, and better yet, you can see the nested security groups too!

This easy-to-read report puts all of the vital details that you need for troubleshooting at your fingertips! No longer do you have to guess or open multiple Active Directory User and Computer (ADUC) consoles just to see the security group memberships of a single user!

Power BI

List of Security Groups for an AD User - Power BI


List of Security Groups for an AD User - SSRS

List of Security Groups for an AD User Button

Enhansoft Reporting – List of Security Groups for an AD User

The List of Security Groups for an AD User report is found within Enhansoft Reporting’s Local Accounts and Groups category. This category of reports provides details about local accounts on each computer as well as the membership of each local security group. This is particularly useful when performing a security audit of all computers within your Configuration Manager environment. Once this category of reports is installed, you can also create a collection with all of the computers that have a particular application or program.

The full report set of Local Accounts and Groups includes:

· Count of Local Accounts

· List of Computers with Local Account Name

· Count of Accounts within Local Computer Groups

· List of Local Computer Groups for an Account

· Members of a Local Computer Group (Recently Updated)

· Local Account-Group Details for a Computer

· List of Users by AD Security Group (New)

· List of Security Groups for an AD User (New)

Would you find it useful to know all of the AD security groups a user belongs to in one report? Then get the List of Security Groups for an AD User report NOW!

Are you looking for another ConfigMgr/SCCM/MEMCM report? Are you looking for Power BI reports? Do you find that Configuration Manager reporting is difficult? Reporting shouldn’t be hard and with Enhansoft Reporting’s 150+ reports, sorted into 26 different categories, we make it easy for you!

Find out more about the reports in Enhansoft Reporting by clicking on any of the 26 category buttons below.

Still not sure that we have the right report for you? Just ask and we will be more than happy to help you out! Send a note to

All of our free reports have the Role-Based Administration (RBA) feature enabled. This means that whether you are using Configuration Manager Current Branch or System Center 2012 R2 Configuration Manager, these reports will work with all RBA settings.

Do you have an idea for a report set that you would like us to create? Submit them to our Ideas page, or drop us a line on Facebook or Twitter!

Leave a Comment

Share via
Copy link