Powershell include variable in output csv

Question

How can I easily add the input country to each line in the output csv file so that if I execute this with several countries for the country parameter I get the country info on each line?

param([string[]]$Country="Norway",[string]$file="ExUsersNO.csv")

Import-Module ActiveDirectory
foreach ($i in $Country)
{
    Get-ADUser -searchbase "ou=$i,ou=FMS,dc=xx,dc=xx,dc=com" -Filter * -properties msExchVersion,name,mail,DistinguishedName,whenCreated |
    Select-Object -Property name,mail,DistinguishedName,msExchVersion,whenCreated |
    Sort-Object name |
    Export-Csv -Path ".\$file" -Append -Encoding UTF8
}

Mathias R. Jessen · Accepted Answer · 2016-05-20 10:17:10Z

2

Use a calculated property with your select statement:

select name,mail,DistinguishedName,msExchVersion,whenCreated,@{Name='Country';Expression={$i}}

edited May 20, 2016 at 10:17

answered May 20, 2016 at 9:00

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

2 Comments

Morten Lunde Over a year ago

Thanks, It worked like a charm! (But I had to change the "," to ";" from ...'Country',Expression... to ...'Country';Expression...

Mathias R. Jessen Over a year ago

Sorry about that, typo on my part. If it solved your problem, please "accept" the answer by clicking the checkmark on the left

Collectives™ on Stack Overflow

Powershell include variable in output csv

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