Configure Microsoft Defender for Endpoint to stream Advanced Hunting events to your Storage account

Applies to:

Want to experience Defender for Endpoint? Sign up for a free trial.

Before you begin

  1. Create a Storage account in your tenant.

  2. Log in to your Azure tenant, go to Subscriptions > Your subscription > Resource Providers > Register to Microsoft.insights.

Enable raw data streaming

  1. Log in to Microsoft Defender for Endpoint portal as a Global Administrator or Security Administrator.

  2. Go to Data export settings page on Microsoft Defender Security Center.

  3. Click on Add data export settings.

  4. Choose a name for your new settings.

  5. Choose Forward events to Azure Storage.

  6. Type your Storage Account Resource ID. In order to get your Storage Account Resource ID, go to your Storage account page on Azure portal > properties tab > copy the text under Storage account resource ID:

    Image of event hub resource ID1

  7. Choose the events you want to stream and click Save.

The schema of the events in the Storage account

  • A blob container will be created for each event type:

    Image of event hub resource ID2

  • The schema of each row in a blob is the following JSON:

            "time": "<The time WDATP received the event>"
            "tenantId": "<Your tenant ID>"
            "category": "<The Advanced Hunting table name with 'AdvancedHunting-' prefix>"
            "properties": { <WDATP Advanced Hunting event as Json> }
  • Each blob contains multiple rows.

  • Each row contains the event name, the time Defender for Endpoint received the event, the tenant it belongs (you will only get events from your tenant), and the event in JSON format in a property called "properties".

  • For more information about the schema of Microsoft Defender for Endpoint events, see Advanced Hunting overview.

  • In Advanced Hunting, the DeviceInfo table has a column named MachineGroup which contains the group of the device. Here every event will be decorated with this column as well. See Device Groups for more information.

Data types mapping

In order to get the data types for our events properties do the following:

  1. Log in to Microsoft Defender Security Center and go to Advanced Hunting page.

  2. Run the following query to get the data types mapping for each event:

    | getschema
    | project ColumnName, ColumnType 
  • Here is an example for Device Info event:

    Image of event hub resource ID3