Connecting to a Microsoft Defender for Endpoint asset data source

The Microsoft Defender for Endpoint Connected Assets and Risk connector can be run in the IBM Security QRadar® Suite Software cluster. The connector incrementally synchronizes the contents of the Microsoft Defender for Endpoint asset databases with the data that is managed by the Connected Assets and Risk service.

Before you begin

Collaborate with a Microsoft Defender administrator to set the permissions that are required for your user account. The following permissions are required for the Microsoft Defender for Endpoint Connected Assets and Risk connector.

Microsoft Graph
  • User.Read
  • User.Read.All
WindowsDefenderATP
  • AdvancedQuery.Read
  • AdvancedQuery.Read.All
  • Alert.Read.All
  • Alert.ReadWrite.All
  • Machine.Read
  • Machine.Read.All
  • Machine.ReadWrite
  • Machine.ReadWrite.All
  • User. Read.All

The API access requires OAuth2.0 authentication.

Generate an ATP access token by completing the following steps.

  1. Create an Azure Active Directory application.
  2. Get an access token that uses this application. Use the token to access the Microsoft Defender for Endpoint API.

For more information, see Create an app to access Microsoft Defender for Endpoint without a user.

About this task

The QRadar Suite Software CAR connector for Microsoft Defender for Endpoint is designed to work with the api/advancedqueries/run, api/machines, and api/alerts API endpoints. For more information about these API endpoints, see Supported Microsoft Defender for Endpoint APIs (https://docs.microsoft.com/en-us/microsoft-365/security/defender-endpoint/exposed-apis-list?view=o365-worldwide).

Microsoft Defender for Endpoint is an endpoint security platform to prevent, detect, investigate, and respond to advanced threats. For more information about Microsoft Defender for Endpoint, see Microsoft Defender for Endpoint (https://www.microsoft.com/en-us/microsoft-365/windows/microsoft-defender-atp).

The Microsoft Defender for Endpoint schema is made up of multiple tables that provide either event information or information about devices and other entities. To effectively build queries that span multiple tables, you must understand the tables and the columns in the schema.

The following table outlines Microsoft Defender for Endpoint schema table names and descriptions.

Table 1. Microsoft Defender for Endpoint schema
Table name Description
AlertEvents Alerts on Microsoft Defender Security Center
MachineInfo Machine information, including OS information
MachineNetworkInfo Network properties of network devices, including adapters, IP addresses, MAC addresses, connected networks, and domains
ProcessCreationEvents Process creation and related events
NetworkCommunicationEvents Network connection and related events
FileCreationEvents File creation, modification, and other file system events
RegistryEvents Creation and modification of registry entries
LogonEvents Sign-ins and other authentication events
ImageLoadEvents DLL loading events
MiscEvents Multiple event types, including events that are triggered by security controls such as Windows Defender Antivirus and Exploit Protection

Procedure

  1. Log in to IBM Security QRadar Suite Software.
  2. From the menu, click Connections > Data sources.
  3. On the Assets tab, click Connect an asset.
  4. Click Microsoft Defender for Endpoint, then click Next.
  5. Configure the connection to allow IBM Security QRadar Suite Software to connect to the data source.
    1. In the Connector name field, assign a name to uniquely identify the data source connection.
      Tip: Only alphanumeric characters and the following special characters are allowed: - . _
    2. In the Connector description field, write a description to indicate the purpose of the data source connection.
      Tip: Only alphanumeric characters and the following special characters are allowed: - . _
    3. In the Edge gateway (optional) field, specify which IBM® Security Edge Gateway to use.

      To use the Edge Gateway to host the containers that are required for communication between the data sources and IBM Security QRadar Suite Software, select an Edge Gateway. The Edge Gateway must be version 1.6 or later. It can take up to 5 minutes to establish the connection to the Edge Gateway.

      Important: If you have a firewall between your IBM Security QRadar Suite Software cluster and the data source target, use the Edge Gateway to host the containers.

      For more information, see Edge Gateway.

    4. In the Frequency field, set how often the connector imports data from the data source, in minutes.
      The value must be an integer.
      For example, a value of 60 causes the connector to run every 60 minutes.
      If the data source doesn't have many assets, or you don't want to import data often, reduce the frequency.
    5. In the Host Port field, set the port number that is associated with the data source host. The default port is 443.
  6. Click Add a Configuration.
  7. Configure identity and access.
    1. In the Configuration name field, enter a unique name to describe the access configuration and distinguish it from the other access configurations for this data source connection that you might set up. Only alphanumeric characters and the following special characters are allowed: - . _
    2. In the Configuration description field, enter a unique description to describe the access configuration and distinguish it from the other access configurations for this data source connection that you might set up. Only alphanumeric characters and the following special characters are allowed: - . _
    3. In the Subscription ID field, enter your Microsoft Defender for Endpoint subscription ID
    4. In the Tenant ID field, enter your Microsoft Defender for Endpoint tenant ID (a UUID).
    5. In the Client ID field, enter your Microsoft Defender for Endpoint client ID (a UUID).
    6. In the Client Secret field, enter your Microsoft Defender for Endpoint client secret.
    7. Click Add.
    8. To save your configuration and establish the connection, click Done.
  8. To edit your configurations, complete the following steps:
    1. On the Assets tab, select the data source connection that you want to edit.
    2. In the Configurations section, click Edit Configuration (Edit configuration icon).
    3. Edit the identity and access parameters and click Save.

Results

The connector imports data from the data source. The connector imports data again at the interval that you set in the Frequency field.

Tip: After the data source is connected, it takes some time for the initial data retrieval based on the frequency that is specified in the Frequency parameter. During this time, the data source appears as unavailable. After the data retrieval is complete, the data source shows as connected. To maintain the connection status, a polling mechanism is initiated to verify the connection periodically.

You can add other connection configurations for this data source that have different users and different data access permissions.

What to do next

Test the connection by searching for an IP address in IBM Security Data Explorer that matches an asset data source. In Data Explorer, click an IP address to view its associated assets and risk.

To use Data Explorer, you must have data sources that are connected so that the application can run queries and retrieve results across a unified set of data sources. The search results vary depending on the data that is contained in your configured data sources. For more information about how to build a query in Data Explorer, see Build a query.