powershell - New-Item : Access to the path is denied -

i have powershell script below

$ous = 'ou=office,dc=xxx,dc=com',`        'ou=shop0,dc=xxx,dc=com',`        'ou=shop1,dc=xxx,dc=com',`        'ou=shop2,dc=xxx,dc=com' $outfile = 'c:\work\userinfo.csv'  new-item  -force -type "file" -path 'c:\work\userinfo.csv'  $ous | foreach {      get-aduser -filter * -searchbase $_ |     select-object -property cn,`         displayname,`         givenname,`         surname,`         samaccountname,`         passwordexpired,`         mail,`         description,`         office,`         employeenumber,`         title |     sort-object -property name |     export-csv -append $outfile -notypeinformation      } 

then when run it, got error message "new-item: access path c:\work\userinfo.csv" denied.

what's cause error?

update:

in case, somehow, powershell case-sensitive....the output folder name uppercase, in script lowercase, works after match them.

i bypassing reason error ( of i'm not sure of cause.). way want

each time run script, fresh result without previous results

you need move output code outside loop , remove append. pipeline handles append you.

$ous | foreach {      get-aduser -filter * -searchbase $_ |     select-object -property cn,`         displayname,`         givenname,`         surname,`         samaccountname,`         passwordexpired,`         mail,`         description,`         office,`         employeenumber,`         title               } | sort-object -property name |     export-csv -append $outfile -notypeinformation 

noticed something

you not calling properties using in select statement. should lead null columns in output. update code this.

$props = "cn","displayname","givenname","surname","samaccountname","passwordexpired","mail","description","office","employeenumber","title"    $ous | foreach-object {      get-aduser -filter * -searchbase $_ -properties $props | select-object $props            } | sort-object -property name |     export-csv $outfile -notypeinformation