Create a CSV with all AD users to import into Elastix

Question

I'm working in a test environment with about 1000 users and I'm trying to create a CSV with the following headers to be used in Elastix: Display Name, User Extension, Secret, Tech.

The users currently do not have extensions assigned to them and random extensions would be fine. The secret will be "123456" for all of them. The Tech will be "Sip" for all of them.

Currently I have this, but I'm struggling to strip the name off each user in my loop:

$users = get-aduser -filter * | Select Name
$outpath = "C:\scripts\users.csv"
$outputArray =@()
"Display Name, User Extension, Secret, Tech"|out-file $outpath -Force
$ext = 1000
foreach($row in $users)
{
    $outputArray +=  "," + $ext++ + "," + "123456" + "," + "Sip"
}

$outputArray | out-file $outpath -Force

I updated the original post with what I have trying so far. – Jarretman Mar 02 '16 at 17:50 — Jarretman, Mar 02 '16 at 17:50

score 0 · Answer 1 · edited May 23 '17 at 12:24

Use can do this using the Select-Object cmdlet with 'calculated properties' and the Export-Csv cmdlet.

(Note: In my original answer I did not specify the script scope for the randomExtension variable when modified in an expression. When trying to fix, I found the solution here: How can I increase the value of a variable in an expression?

$outputPath = "C:\test\users.csv"
$script:randomExtension = 1000
get-aduser -filter * | 
Select @{n='Display Name';e={$_.Name}}, 
   @{n='User Extension';e={$script:randomExtension++; $script:randomExtension}},
   @{n='Secret';e={'123456'}},
   @{n='Tech';e={'Sip'}} |
Export-Csv -Path $outputPath -NoTypeInformation

Thank you this is exactly what I was looking for! However, the fields for the User Extension are coming out as blank. I'm working on a way to fix that. — Jarretman, Mar 02 '16 at 19:13

Create a CSV with all AD users to import into Elastix

1 Answers1