Error in Security Center CSV?

Naldal, Sara Lee 1 Reputation point
2020-07-09T08:08:03.11+00:00

I have tried exporting my Security Center recommendations to a CSV, but the downloaded CSV-file contains errors in the encoding. Specifically the column titled 'remediation steps' causes problems, as the step by step descriptions get sorted into separate columns rather than the string in that row of the csv file. This for instance happens for the remediation steps for enabling MFA.

This causes issues when transforming the data to an excel file.

Is this just me, or is there a way to put a filter on the csv file to exclude the remediation descriptions?

Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,262 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ken Golitin 21 Reputation points
    2020-07-09T13:19:52.25+00:00

    Hi,
    Strange enought I already have replied and it disapeared :/

    I can see an issue because in a field there is a "," when this is the separator used by the file.

    Edit the file with notepad, search for the character ;

    • if there is no result, replace the text: ","
    • by the text: ";"

    Note: Don't omit the quotes.

    replace in all the file save and importe in excel.

    I hope that help.
    KEN


  2. Saurabh Sharma 23,791 Reputation points Microsoft Employee
    2020-07-10T14:53:25.717+00:00

    @NaldalSaraLee-6508 Can you please share the downloaded csv file to azcommunity[at]microsoft[dot]com with the thread title so that I can look into your issue.