Forum Discussion

Sushantjha's avatar
Sushantjha
Copper Contributor
Sep 28, 2020

bulk update extension attribute in AD

I have written below script to update the extension attribute and after updating I want the report in CSV. If I run till update it is working fine but when I am adding select-object to take the entr...
Active Directory
Sushantjha's avatar
Sushantjha
Copper Contributor
Sep 29, 2020

farismalaeb 

 

I have made the below changes but each iteration of foreach loop saves to $Output. It overwriting what was there previously, i.e., the previous iteration. Which means that only the very last iteration is saved to $Output and exported.

 

Import-Csv -path c:\temp\SetExtAtt1.csv |ForEach-Object {
$Output = @()
Set-ADComputer $_.samAccountName -replace @{
ExtensionAttribute4 = "$($_.ExtensionAttribute4)"
ExtensionAttribute6 = "$($_.ExtensionAttribute6)"}
$Output =New-Object -TypeName PSObject -Property @{
samAccountName = "$($_.samAccountName)"
ExtensionAttribute4 = "$($_.ExtensionAttribute4)"
ExtensionAttribute6 = "$($_.ExtensionAttribute6)"
}
}
$Output | Export-Csv C:\Temp\OwnerTest2.csv -NoTypeInformation -Encoding UTF8 -Append
  • farismalaeb's avatar
    farismalaeb
    Iron Contributor
    Sep 29, 2020

    Sushantjha 

    Yes, sure as the $Output=@() is inside the loop and is being reset everytime, a very quick fix will be to add a new variable at the top

    and once the $output have the result, add it to the variable

    try the code below and get the result from $allresult variable.

    $allresult=@()
Import-Csv -path C:\123\EXDB1.csv |ForEach-Object {
$Output = @()
Set-ADComputer $_.samAccountName -replace @{
ExtensionAttribute4 = "$($_.ExtensionAttribute4)"
ExtensionAttribute6 = "$($_.ExtensionAttribute6)"}
$Output =New-Object -TypeName PSObject -Property @{
samAccountName = "$($_.samAccountName)"
ExtensionAttribute4 = "$($_.ExtensionAttribute4)"
ExtensionAttribute6 = "$($_.ExtensionAttribute6)"
$allresult=$output
}
}
$Output | Export-Csv C:\Temp\OwnerTest2.csv -NoTypeInformation -Encoding UTF8 -Append

     

    • Sushantjha's avatar
      Sushantjha
      Copper Contributor
      Sep 29, 2020

      farismalaeb 

       

      Still last iteration is saved to $Output and exported, I am not getting all the results.

Resources