Power Shell - Quest - How to pull all the group membership for multiple users

Hi EE

Any easy way to put a list of sAMAccountNames into a text file and have it output all the group memberships for each account into a .CSV file ?
LVL 2
MilesLoganAsked:
Who is Participating?
 
SubsunConnect With a Mentor Commented:
I guess you didn't select the description property..
Change last line to..
} | Select Firstname,Lastname,DisplayName,Email,Title,description,group | Export-Csv C:\report.csv -NoTypeInformation

Open in new window

0
 
SubsunCommented:
Try this...
GC C:\user.txt | Get-QADUser | %{
	New-Object PSObject -Property @{
	Firstname = $_.Firstname
	Lastname = $_.Lastname
	DisplayName = $_.DisplayName
	Email = $_.Email
	Title = $_.Title
	group = ""
	}
$_.memberof | %{
	New-Object PSObject -Property @{
	Firstname = ""
	Lastname = ""
	DisplayName = ""
	Email = ""
	Title = ""
	group = ($_ -Split ",")[0] -replace "CN="
	}
 }
} | Select Firstname,Lastname,DisplayName,Email,Title,group | Export-Csv C:\report.csv -NoTypeInformation

Open in new window


Ref : http://www.experts-exchange.com/Programming/Languages/Scripting/Powershell/Q_28085213.html
0
 
MilesLoganAuthor Commented:
Hi SubSun

It works perfect ! I tried to modify it so it also pulls the account description but it did not work .. can you give me a hit ?

I added the two lines below but it did not output it .


description = $_.description
Description = ""
0
 
MilesLoganAuthor Commented:
Awesome as always !

Thank you so much again !
0
 
SubsunCommented:
You are welcome, I'm glad I was able to help... :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.