Using PowerShell to get a user's group info

[chrisrhode]

I have this script below which will pull an individual user’s account information and post it into a .txt file in my home directory for reference if the employee ever gets hired back to the company for the same position. My manager just gave me a list of 600 users this morning that I need to get the information from. I am at a loss as to how to import a csv file and have this script run on each user in the csv. Any help would be greatly appreciated.

[CmdletBinding(SupportsShouldProcess=$True)]
Param(
	[Parameter(Mandatory = $True)]
	[String]$UserName
)
Import-Module ActiveDirectory
    If ($UserName) {
	   $UserName = $UserName.ToUpper().Trim()
	   $Res = (Get-ADPrincipalGroupMembership $UserName | Measure-Object).Count
	   If ($Res -GT 0) {
		  Get-ADPrincipalGroupMembership $UserName | Select-Object -Property Name, GroupScope, GroupCategory | Sort-Object -Property Name | format-table -Autosize | out-file "\\server\network\home\($UserName).txt"
	   }
    }

[martin9700]

So, assuming the SamAccountName in the CSV you have is called UserName:

Import-Csv c:\path\to\your\csv\Users.csv | % { c:\Path\to\your\script\Get-Groups.ps1 -Username $_.Username }

[jacobdurham (Jacoby)]

Did you write this yourself?

You need to to use import-csv and foreach-object here. Neally or Jiten will be along shortly to show the exact command but it should look like:

import-csv "path/to/file.csv" | foreach-object {script}

@alexw @jitensh

[chrisrhode]

Awesome! It’s working like a dream Martin9700! Thank you for your quick reply, this just saved me a few hours of typing.

@martin9700

[big-green-man]

@martin9700

So, assuming the SamAccountName in the CSV you have is called UserName:

Import-Csv c:\path\to\your\csv\Users.csv | % { c:\Path\to\your\script\Get-Groups.ps1 -Username $_.Username }

I didn’t know % was an alias for Foreach-Object. Thanks for that!

[chrisrhode]

I did write this myself with some help from one of the TechNet forums before. I had to do this for a couple of users who had just been let go from the company before so I didn’t see a need to have a csv file at that time. Today my manager wanted to go through AD and clean up any old accounts that have been terminated before I started. Some of these accounts last log on was 2008, so this is well past due.

@jacobdurham

[jitensh]

$users=import-csv c:\list.csv
Foreach($user in $users){
get-aduser $user.username -properties name, memberof | select name, @{n=’MemberOf’; e= { ( $_.memberof | % { (Get-ADObject $_).Name }) -join “,” }} | Sort-Object -Property Name| Export-csv c:\usersinfo.csv -nti
}

you are exporting the list in text file ? that has username in it

 out-file "\\server\network\home\($UserName).txt"

It will get you 600 text files, export in one csv

[chrisrhode]

@jitensh

$users=import-csv c:\list.csv
Foreach($user in $users){
get-aduser $user.username -properties name, memberof | select name, @{n=’MemberOf’; e= { ( $_.memberof | % { (Get-ADObject $_).Name }) -join “,” }} | Sort-Object -Property Name| Export-csv c:\usersinfo.csv -nti
}

you are exporting the list in text file ? that has username in it

 out-file "\\server\network\home\($UserName).txt"

It will get you 600 text files, export in one csv

At the time I wrote the script that I have, I only had about 10 users that I needed to do. I will update the script to export to a csv file for future use and will also re-run it so that I only have the one output file. Thank you for your input.

@jitensh