PowerShell: Add New Value to Array

Question

Using PowerShell I retrieve information from multiple ActiveDirectory groups and output it to a single CSV file. To each row I want to add the name of the group, in addition to the information retrieved. How can I achieve this?

Desired Result:

"CN","Department","co","Company","Group"
"ABCDEF","Media","UK","Global Entertainment","XXX"

Current Result:

"CN","Department","co","Company"
"ABCDEF","Media","UK","Global Entertainment"

My PowerShell code:

#Roles to check membership for
$Roles= @(
'XXX' 
'YYY'
)

$FolderName = "C:\"
$OutputAD = @()

foreach ($role in $Roles) {
  $GroupMembers = Get-ADGroupMember -identity $role | select name

  $GroupMembersArray = $GroupMembers | Foreach {"$($_.Name)"}

  $GroupMembersArray | ForEach-Object {
    $UserLookup = Get-ADUser -Filter "Name -eq '$_'" -Properties CN,Department,co,Company | Select-Object CN,Department,co,Company
    $OutputAD +=  $UserLookup
  } 

}

$OutputAD | Export-Csv "$FolderName\Membership $(get-date -Format yyyy-MMM-dd-HH-mm-ss).csv" -NoTypeInformation

As an aside: Extending arrays in a loop with += is inefficient, because a new array must be created behind the scenes in every iteration, given that arrays are of fixed size; a much more efficient approach is to use a foreach loop as an expression and let PowerShell itself collect the outputs in an array: [array] $outputs = foreach (...) { ... } - see this answer. In case you need to create arrays manually, e.g. to create multiple ones, use an efficiently extensible list type - see here. — mklement0
– mklement0, Commented Aug 5, 2022 at 13:41

mklement0 · Accepted Answer · 2022-08-05 13:40:04Z

2

Found the solution. In Select-Object you can add a calculated property.

Example: Select-Object CN,Department,co,Company,@{n='Role';e={$role}}

edited Aug 5, 2022 at 13:40

mklement0

452k68 gold badges727 silver badges986 bronze badges

answered Aug 5, 2022 at 13:15

Falco

1211 gold badge1 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

PowerShell: Add New Value to Array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related