PowerShell get CSV and add column from data query

Question

Have a CSV that has headers "SamName", "Email", "UPN"

Each record is how it shows in AD currently.

I am trying to add a 5th column with the ObjectGUID as follows:

$CsvFile = Import-Csv C:\test\file.csv
$CsvFile | ForEach-Object -Process { `
    $data1 = Get-ADUser -Identity $_."SamName" -Properties * | Select-Object ObjectGUID
    $_ | Add-Member -MemberType NoteProperty -Name UserGUID -Value $data1 -PassThru } `
    Export-CSV C:\test\file2.csv

When I open the CSV, the new column is called "UserGUID" as I had expected.

The GUID's that show are like this:

@{ObjectGUID=2e9dddec-f95d-4c67-a374-b102ce7e6f74}

Why don't they just show 2e9dddec-f95d-4c67-a374-b102ce7e6f74 in the column instead?

A second question, is why at the top of the Csv do I see #TYPE System.Management.Automation.PSCustomObject ?

Kory Gill · Accepted Answer · 2018-04-06 04:12:41Z

2

Two guesses to answer your questions...

Select-Object -ExpandProperty ObjectGUID

and

Export-CSV C:\test\file2.csv -NoTypeInformation

See Get-Help for various commands to see all the options.

answered Apr 6, 2018 at 4:12

Kory Gill

7,1711 gold badge28 silver badges35 bronze badges

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

1 Comment

Danijel-James W Over a year ago

Worked a charm! Thank you!

Collectives™ on Stack Overflow

PowerShell get CSV and add column from data query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related