Add a column to a Select output

[g33man]

Below is my script (borrowed from the Internet). It produces a report of all the users in each group.

Import-Module ActiveDirectory
$groups= "GROUP1","GROUP2","GROUP3"
$selectgroups=$groups |Get-Adgroup
$selectgroups |get-adgroupmember -Recursive |Get-ADUser -property sn |Select givenname,sn,userPrincipalName

What I need to do is create a 4th column which is the actual group name (from $groups) that the user came from.

Could this be a clever tweak to my script?
With thanks,
Mike

 

[blister911]

How about something like this?

Import-Module ActiveDirectory
$groups= "GROUP1","GROUP2","GROUP3"
$memberships = @()
foreach ($group in $groups)
	{
	 $members = Get-ADGroupMember $group -Recursive
	 foreach ($member in $members)
		{
		 $user = Get-Aduser $member -Properties sn
		 $record = New-Object PSObject
		 $record | Add-Member -Type NoteProperty -Name GivenName -Value $user.GivenName
		 $record | Add-Member -Type NoteProperty -Name Surname -Value $user.sn
		 $record | Add-Member -Type NoteProperty -Name UserPrincipalName -Value $user.UserPrincipalName
		 $record | Add-Member -Type NoteProperty -Name ParentGroup -Value $group
		 $record
		 $memberships += $record
		}
	}

Light travels faster than sound. That's why some people appear bright until you hear them speak.