How to export AD group members taking input from excel file

Question

I have an excel file where I have all the groups listed. I have been asked to export all the group members. There are almost 500 groups. So I want to take input from my excel file and then export all the members information. I need at least "Group Name" "DisplayName" "samaccount" ,

Answer 1

Hi @Mohd Arif ,

You can convert your Excel file to CSV, this is easly done:

Convert Excel file (XLSX) to CSV in Powershell
https://excel.officetuts.net/examples/convert-excel-file-xlsx-to-csv-in-powershell/

Depending on how your CSV is exactly structured (in particular the headers) you need to do the following:

$Groups = Import-CSV "Path top the CSV" -Header "Column1","Column2"  

Here a reference regarding the import:

Import-Csv
https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/import-csv?view=powershell-7.2

Afterwards you can loop over the groups and get their members:

foreach ($Group in $Groups) {  
  
Get-ADGroupMember -identity $Grooup | select DisplayName, name, samaccountname | Export-csv -path c:\filename.csv -Notypeinformation  
  
}  

You have to just see test it out, but the approach is prettyy straight forward.

Hope I was able to help.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Stoyan Chalakov

Answer 2

It is not working, below error

Get-ADGroupMember : Cannot validate argument on parameter 'Identity'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
At line:5 char:30

• Get-ADGroupMember -identity $Grooup | select DisplayName, name, sama ...
• ~~~~~~~
• CategoryInfo : InvalidData: (:) [Get-ADGroupMember], ParameterBindingValidationException
• FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.GetADGroupMember

Answer 3

Out Put is not in correct format. I need output like "Group Name", "Username for example aktir, akdie" "Display Name for example, Atif Khan"
]1

Answer 4

Hi @Mohd Arif ,

what if the user is member of more than one group? Should he/she be listed twice in the export?

Regards,
Stoyan