Find And Export AD Group Members Using PowerShell

How to Find & Export Members Of An AD Group

Finding group member is a task that every AD administrator has dealt with at some point of time. If it is a group with a handful of members, you can use the good old AD Users and Computers snap-in to find the information. But, what if it is a large group and you want the information to be exported to a csv file?

The AD Users and Computers snap-in does not have any option to export the AD group membership. But you can use PowerShell to complete the task and more using the Get-ADGroupMember cmdlet. We will look at the various options and scenarios that a real world demands and try to get the job done using PowerShell.

Install the Active Directory PowerShell Module

Let’s start with the basic cmdlet and build our way up. We need the Active Directory module to be installed on the machine from which we want to run the Get-ADGroupMember cmdlet, unless you are running it from the domain controller itself.

Most organizations will have a management server where the AD tools (RSAT) are installed and that will make the job easier. If you are instead running it from a client machine like Windows 11, make sure that the Remote Server Administration Tools (RSAT) are installed already.

Find & export group members of a simple group

Run the command below if you want to have a look at the group membership of an AD group.

Get-ADGroupMember -identity <groupname>
Get ADGroupMember Cmdlet

Well, the output above has a lot more attributes than I need. I am not that keen on attributes like ObjectGuid. We can further filter the required output using the select parameter.

Get-ADGroupMember -identity <groupname> | select name, samaccountname

If you are happy with the output, you can export the information to a csv file by using export-csv cmdlet.

Get-ADGroupMember -identity <groupname> | select name, samaccountname | export-csv .\Members.csv -notypeinformation

Note that you can specify a location of your choice. Using the command above will export the information to a csv file from the location you are running the one-liner. If you want a different location of your choice, you can specify the path, for example c:\temp\members.csv.

The command will look like below.

Get-ADGroupMember -identity <groupname> | select name, samaccountname | export-csv c:\temp\Members.csv -notypeinformation

Find & export membership of groups with groups nested

The scenario above is pretty straightforward. What if we want to have the group membership of an AD group that has other groups within it (of course, with members).

For example, I have a group named ‘Cloudiffic Team’ with ‘IT Team’ group nested.

Cloudiffic Team Group

Running Get-ADGroupMember ‘Cloudiffic Team’ is going to only list the ‘IT Team’ group as a member, but it will not list the accounts within it.

Get ADGroupMember Cmdlet with groups as members 1

Run the command below if you want to get the membership of the group within as well.

Get-ADGroupMember -identity <groupname> -Recursive | select name, samaccountname

You can see that the ‘IT Team’ group entry is replaced by the user account, who is a member of the group.

Get ADGroupMember Cmdlet with groups as members recursive

As always, you can export the information by piping the output to export-csv cmdlet.

Get-ADGroupMember -identity <groupname> -Recursive | select name, samaccountname | export-csv .\Members.csv -notypeinformation

Find & export group membership with additional attributes

Having the above information is pretty good in most cases. But, sometimes we might end up in a situation where we need the email address of the user (for example).

The Get-ADGroupMember cmdlet doesn’t bring that info back and the above commands need to be modified & piped to Get-ADUser to find the user attributes that you need.

Run the command below to find the group membership along with the user’s email addresses.

Get-ADGroupMember -Identity <groupname> | Get-ADUser -Properties mail | select name, mail
Get ADGroupMember Cmdlet with email address

If you want to find the same info along with users from the groups within, use the Recursive parameter.

Get-ADGroupMember -Identity <groupname> -Recursive | Get-ADUser -Properties mail | select name, mail

Use the export-csv cmdlet to extract the info into a csv file.

Get-ADGroupMember -Identity <groupname> -Recursive | Get-ADUser -Properties mail | select name, mail | export-csv .\Members.csv -notypeinformation

Find & export members of groups with users & contacts

Now that we have tackled to get the users within a group along with membership from any nested groups, how can we also get information of contacts that may be part of a group?

Run the command below to get the membership of an AD group with users and contacts within it.

Get-ADGroup <groupname> -Properties member | select-object -ExpandProperty member

Please let me know if you have any questions in the comments section.

Other Popular Articles


Promote Windows 2025 To Domain Controller

Promote Windows Server 2025 To Domain Controller

Force Ping To Respond With An IPv4 Address

Force Ping To Respond With IPv4 Address

How To Fix GetADGroupMember Size Limit Exceeded Error

Get-ADGroupMember – The size limit for this request was exceeded error

Leave a Comment

Disable Windows Copilot Using Intune

Windows Copilot is Microsoft’s take on making life easier for Windows users using the power of AI. This article explains how to disable the feature using Intune, if your organization is not ready yet to walk into the AI world.

Disable Windows Copilot Using Intune

We need to create a Configuration Profile for Windows devices in the Intune portal to disable Windows Copilot. Below are the steps that we need to create the profile.

Launch the Intune Portal and login as a Global Admin or Intune Admin.

Navigate to Devices -> Windows -> Configuration Profiles.

Windows Configuration Profile Intune

Click on Create -> New Policy.

Select Windows 10 & later as the platform and Settings Catalog as the profile type & click on the Create button.

Settings Catalog Intune CoPilot

Give the policy a meaningful name & description and click Next.

Policy Name Disable CoPilot

Within the configuration settings, click on the Add Settings option.

Add Settings Disable CoPilot

Search for ‘copilot’, Windows AI will come up as the category. Click on Windows AI and the Turn off Copilot in Windows (User) setting will come up. Check the box and click Next.

Turn off CoPilot Setting Intune
Turn off CoPilot Setting Intune Summary 1

Specify scope tags if required and click Next.

Select tags CoPilot Intune

Select who this policy should apply to in the Assignments section. I have selected to add all users. If you want to test the setting, you can create a test group and select that group here.

Similarly, you can also exclude certain group from disabling AI (say IT team) if required.

Add all users disable copilot intune

A summary of selected settings will be displayed. Click on the Create button to setup the policy to disable Windows Copilot.

Create configuration policy disable CoPilot Intune 1

Wait for the replication to complete in the cloud backend and login to your machine. Your chatty Copilot should now be disabled.

Disable Windows Copilot On Windows 11 Pro

Follow the steps below to disable Copilot on a personal Windows 11 Pro machine (say your own laptop).

Search for ‘group’ in Windows 11 and click on Edit Group Policy option.

Group Policy Windows 11 Disable Copilot

Navigate to User Configuration -> Administrative Templates -> Windows Components -> Windows Copilot.

Windows Copilot GPO setting

Double click on Turn off Windows Copilot setting on the right pane.

Select Enabled and click OK.

Turn off copilot gpo Windows 11 Pro 1

Close the Group Policy Editor. This will disable Windows Copilot on a Windows 11 Pro machine.

Summary

We have learned to disable Windows Copilot using Intune and Group Policy on Windows 11 machines.

Please let me know if you have any questions in the comments section.

Promote Windows Server 2025 To Domain Controller

Domain controllers are the backbone of any Active Directory domains in the Microsoft world. Any Windows server can be promoted to be a domain controller. In this article, we will go through the steps of promoting a Windows 2025 Server to be a domain controller.

Windows Server 2025

The latest version of the server operating system has been named Windows Server 2025. You can start with a 2025 Server & create an AD domain or you can promote a member server that is already a part of a domain.

The Windows Server 2025 needs to be installed on a machine before it can be promoted to be a domain controller.

Promote Windows Server 2025 To Domain Controller

If you have been working with Windows servers long enough, everything starts with the Server Manager app. Promoting a server to a domain controller is no different.

Launch ‘Server Manager’ & click on Add roles and features.

Windows 2025 Server Manager

You land on the summary page that explains what is required to run this wizard successfully. Click Next.

Windows Server 2025 Add Remove Roles

Select Role-based or Feature-based installation and click Next.

Windows Server 2025 Role Based Install

Select the server that needs to be promoted and click Next.

Windows Server 2025 Destination Server

Select Active Directory Domain Services (second option) and click on Add Features.

Windows Server 2025 AD Domain Services

Go with the default options for features that need to be installed.

Windows Server 2025 AD Domain Services Features

A summary of AD DS pops up next, click next to continue.

Windows Server 2025 AD DS

Select Restart the server automatically if required and click Install.

Windows Server 2025 AD Restart Server

You get to keep an eye on the progress of the installation.

Windows Server 2025 AD Install Progress

Once the role has been installed, you will find an exclamation mark on the top right corner of the Server Manager. Click on that and select Promote this server to be a domain controller.

Windows Server 2025 AD Install Continue

You get an error straight away (which you have never seen before) – Error determining whether the target server is already a domain controller. Role change is in progress or this computer needs a restart.

Windows Server 2025 Domain Controller Setup Error

We never needed to restart the server after installing the role in the DC promotion process. Given that it is an insider build of Server 2025, I am hoping that this will get fixed before the public release.

Restart the server, launch Server Manager and click on the Promote this server to be a domain controller option again.

Windows Server 2025 AD Install Continue 1

I am setting up a brand new AD forest and hence I select the third option (Add a new forest) and enter my root domain name.

Windows Server 2025 Add a forest

Next window brings the option to set your forest & domain functional level and the DSRM password. In the insider build, it shows what looks like a variable (the Windows server version on which the you are working).

Windows Server 2025 Forest Functional Level

You can leave the default options in the DNS options wizard and click next.

Windows Server 2025 DNS Options

Enter the netbios name of the domain in the next window and click next.

Windows Server 2025 Netbios Domain Name

You can stick with the default paths for the AD database, log & sysvol folder or pick a location of your choice.

Windows Server 2025 AD Paths

Review the selections that you have made so far and click next.

Windows Server 2025 Options Review

Wait for the green check mark on the prerequisites page and click next.

Windows Server 2025 Pre reqs Check

Click Install in the final window & wait for the magic to happen. Once the machine gets restarted (which it will do automatically), you will have a brand new domain controller based on Windows Server 2025.

Windows Server 2025 AD Snap In

Summary

Promoting a Server 2025 to a domain controller follows pretty much the same steps as previous operating systems. The Insider build has few errors that needs to be fixed, but hey, it is an insider build!

Please let me know if you have any questions in the comments section.

Install Windows Server 2025 – Full Guide

Microsoft has released an insider preview of it’s next server operating system named Windows Server 2025. We will have a look at the installation steps involved in setting up a 2025 server.

Windows Server 2025

Microsoft has gone with the same look and feel of Windows 11 operating system in it’s current server operating system – Windows Server 2025. As the product is in insider preview, there might be slight changes before it hits the public shelves.

It is refreshing to see a ‘modern’ feel in the installation process of a server operating system. Gone are the days where the installation of a consumer based OS felt much better compared to it’s server counterpart.

Installing Windows Server 2025

Let’s take a look at the steps involved in setting up a Windows Server 2025 machine. First step is to download the ISO from the Windows Insider portal.

Next step is to boot the virtual / physical machine from the ISO which will kick off the installation of Server 2025.

First option to select is the language settings. Pick the one based which relates to you and click next.

Windows Server 2025 language settings

Select the keyboard settings in the next screen and click next.

Windows Server 2025 keyboard

You get the option to select whether you want to Install Windows Server or Repair the installation. The bottom left corner also has the option to go to the previous version of setup.

Windows Server 2025 setup option

You are asked to enter the product key, which is available in the Windows Insider portal.

Windows Server 2025 product key

Next option to choose is the type of image you want to install – Windows 2025 core or full blown desktop experience.

Windows Server 2025 Desktop

You need to agree to the licensing terms to move forward in the next step.

Windows Server 2025 Agreement License

Select the partition on which the server OS should be installed and click next. You also have the option to slice the partitions the way you see fit in the same screen.

Windows Server 2025 Disk Partitions

The Ready to Install window comes up, click the install button.

Windows Server 2025 Install 1

Installation of Server 2025 is underway and you get to see the progress.

Windows Server 2025 Install Progress

Once the installation is complete, you need to enter an administrator password of your choice to finalize the setup.

Windows Server 2025 Password

And there you go! You see a Windows 11 login screen staring at you ;-)

Windows Server 2025 Login Screen

After logging in, you get to set the options around sending diagnostic data to Microsoft, which I always set as ‘required only’.

Windows Server 2025 Diagnostic Data

The Windows Server 2025 desktop looks similar, doesn’t it? ;-)

Windows Server 2025 Desktop Feel scaled

Now that the server is up and running, you can promote it to be a domain controller.

Summary

The Windows Server 2025 has the same look and feel as a Windows 11 operating system. The installation options also provide that modern ‘feel’ and makes it a bit soothing to the eyes!

Please let me know if you have any questions in the comments section.