This project has moved. For the latest updates, please go here.

Errors in CSV output

Jan 15, 2016 at 4:07 AM
Edited Jan 15, 2016 at 4:08 AM
Hi All,

Love the script! So happy I don't have to code this myself!

I have encountered a couple if issues though:
  1. I have found that "S-1-5-32-548" and others are not being translated to "BUILTIN\Account Operators" etc.
  2. The CSV export is not playing friendly with Excel (2010 at least). It seems quoting all fields is confusing the auto import column reader. If possible switching to the dedicated Export-Csv cmdlet would automatically overcome this.
Feb 10, 2016 at 6:18 PM
Hi Mick,
  1. That's true,. Reason is that the method used behaves differently between running on a DC and a domain member.
  2. The CSV file is only intended for comparing. The file is a comma separated file so it's using comma, so it depends on what character you are using as a list separator. Check your regional settings in Control panel. I'm not sure Export-Csv would solve this.
I create a HTML report and cut and paste in to Excel. Not the simplest method, but it works fine for me.