How to get multiple users membership groups from AD using Powershell script?

Question

I got a list of 150+ users and I want to know which group they have membership for? I just started using PS. I can query for 1 user, but not for a list of users. Would like to know exact command??? I got :

(get-aduser -identity "username" -properties memberof |select-object memberof).memberof > c:\temp\ss.csv

Ansgar Wiechers · Accepted Answer · 2018-01-05 09:08:56Z

1

Read your user list into an array and check if your AD users are contained in that array:

$userlist = Get-Content 'C:\your\userlist.txt'

Get-ADUser -Filter '*' -Properties memberof | Where-Object {
  $userlist -contains $_.SamAccountName
} | ForEach-Object {
  $username = $_
  $groups = $_ | Select-Object -Expand memberof |
            ForEach-Object { (Get-ADGroup $_).Name }
  "{0}: {1}" -f $username, ($groups -join ', ')
} | Out-File 'c:\temp\ss.csv'

Replace SamAccountName as appropriate if the user list doesn't contain the account names of the users.

edited Jan 5, 2018 at 9:08

answered Nov 13, 2014 at 9:30

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Svi Over a year ago

Sorry to ask, we save this script as .vbs?

Svi Over a year ago

Hi Ansgar, your script is returning error. Can you check n post it again? Thx.

Ansgar Wiechers Over a year ago

@Svi It's PowerShell, not VBScript, so it should be saved as .ps1. And the code works just fine. If you're getting an error, please update your question with the code you used and the error it produced.

Svi Over a year ago

Hi, my userlist.txt file structure is like: accountname zachem adelto

Svi Over a year ago

my script is saved as grpname.ps1 and code in it is : $userlist = Get-Content 'C:\temp\del\userlist.txt' Get-ADUser -Filter 'accountname' -Properties memberof | ? { $userlist -contains $_.AccountName } | select -Expand memberof > 'c:\temp\del\ss.csv' it's not giving error, but not giving any output too ?

|

Collectives™ on Stack Overflow

How to get multiple users membership groups from AD using Powershell script?

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related