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 Integration data sources page, on the Microsoft Defender for Endpoint tile, click Set up a connection.
  4. On the Connection services page, select the Connected assets & risk service tile, and then click Enable.
    The available connection services include:
    1. Connected assets & risk
    2. Federated searches
    Note: If there are multiple data sources to connect, select the connector from the Sources list, and then click Enable.
  5. Click Next.
  6. On the Connection details page, configure the following parameters.
    1. Configure the connection to the data source.
      Table 2. Connection parameters
      Parameter Description
      Data source name Enter a unique name to identify the data source connection. You can create multiple connections to a data source, so it is useful to clearly set them apart by name.

      Only alphanumeric characters and the following special characters are allowed: - . _

      Data source description Enter a description to indicate the purpose of the data source connection. You can create multiple connections to a data source, so it is useful to clearly indicate the purpose of each connection by description.

      Only alphanumeric characters and the following special characters are allowed: - . _

      Edge gateway If you have a firewall between your cluster and the data source target, use the Edge Gateway to host the containers. In the Edge gateway field, specify an Edge Gateway to host the connector.

      It can take up to five minutes for the status of newly deployed data source connections on the Edge Gateway to show as being connected.

      Frequency Set how often the connector imports data from the data source, in minutes. The value must be an integer.

      For example, a value of 5 causes the connector to run every 5 minutes. If the data source doesn't have many assets, or you don't want to import data often, reduce the frequency.

    2. Click Next.
    3. If Microsoft Azure is configured with a self-signed Security Sockets Layer (SSL) certificate, add a connection certificate.

      To confirm that you have a self-signed certificate, you can search the web for 'ssl decode', then copy and paste your certification into a Certificate Decoder. If the value in the Common Name field is local, for example: yourlocalhost.yourlocaldomain, it indicates a self-signed certificate.

      If the value of your hostname or IP address does not match the common name value in your certificate, add the hostname to the server that hosts the Edge Gateway.
      Table 3. Adding your hostname to the Edge Gateway server
      If you are running the Edge client If you are not running the Edge client
      Run the following command:
      manageAppHost dns --set --ip <ip_address> --hostname <hostname1> --hostname <hostname2>
      Tip: The <ip_address> is the address of the server that you want to access, and <hostname> is the name of the server. If a server has multiple names, you can add each name by using --hostname.

      You can use --show to see the defined hostnames and --clear to remove a hostname previously set with the manageAppHost command.

      Add the hostname to the server that hosts the Edge Gateway by adding entries to Pod /etc/hosts with HostAliases. To edit the Universal Data Insights worker deployment, run the following command:
      oc edit deployment udi-udiworker
      Add the following information to the host deployment HostAliases, in the spec.template.spec section:
      hostAliases:
         - hostnames:
          - qradar.iseccs.local
          ip: <1.2.3.4>

      For more information, see Adding entries to Pod /etc/hosts with HostAliases (https://kubernetes.io/docs/tasks/network/customize-hosts-file-for-pods/).

    4. Copy the certificate details and paste it in the space that is provided.
    5. Click Next.
  7. On the Connection configurations page, configure identity and access.
    1. Click Add a configuration.
    2. In the Configuration details window, configure the following parameters.
      Table 4. Configuration parameters
      Parameter Description
      Configuration Name 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: - . _
      Configuration Description 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: - . _
      Subscription ID Enter your Microsoft Azure subscription ID.
      Tenant ID Enter your Microsoft Azure tenant ID (a UUID).
      Client ID Enter the client ID for your Microsoft Azure tenant (a UUID).
      Client secret Enter the client secret for your Microsoft Azure tenant.
    3. To save your configuration and establish the connection, click Save.
  8. Click Next.
  9. Click Finish.
  10. To manage your active connections, complete the following steps:
    1. On the Integration data sources page, on the tile of the relevant data source, click Manage <x> of <x> active connections.
    2. On the Connection status page, on the tile of the relevant data source, you can edit, refresh, or delete your data source connection.

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 you connect a data source, the data retrieval time depends on the selected frequency duration (maximum time set in the cronjob). Before the full data set is returned, the data source is in Contacting Service status. After the data is returned, the data source shows as being connected, and will update the connection status for every cronjob run thereafter.

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.