Powershell - concatenate output to csv file

Question

First of all this is my first post, so if there is something I should know about the procedure on Stackoverflow please let me know.

Now, let's get to my problem with powershell. I am creating a powershell script that will retrieve SAMaccountname and ipphone attribute, then export them to csv file.

Import-Module activedirectory

Get-Aduser -filter {ipphone -like "*"} -properties samaccountname,ipphone | select name,samaccountname,ipphone | export-csv "C:\output.csv" -NoTypeInformation

The result is:

namme,samaccount,ipphone

Now... I need a column with domain/samaccountname format instead of standalone samaccountname. What can I do to achieve this?

Mathias R. Jessen · Accepted Answer · 2017-07-11 15:09:48Z

3

Add a calculated property to the property list when using select:

... | select name,samaccountname,ipphone,@{Label='Username';Expression={"DOMAINNAME\$($_.SamAccountName)"}}

edited Jul 11, 2017 at 15:09

answered Jul 11, 2017 at 15:05

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

2 Comments

G42 Over a year ago

PowerShell Tip of the Week explaining/demoing calculated properties

Mathias R. Jessen Over a year ago

@Jona I'm afraid I don't understand the question. Are you trying to merge the properties of two different objects into one object?

Collectives™ on Stack Overflow

Powershell - concatenate output to csv file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related