: Set up IoT Security and XSOAR for SCCM Integration

Set up IoT Security and XSOAR for SCCM Integration

Table of Contents

Set up IoT Security and XSOAR for SCCM Integration

Set up IoT Security and Cortex XSOAR to integrate with Microsoft SCCM.
To set up IoT Security to integrate through Cortex XSOAR with Microsoft SCCM, you must add a Cortex XSOAR engine to your network.
You must also configure a Microsoft integration instance and job in XSOAR for each site from which you want to gather device data. To do this, you need the IP address and port number of your Microsoft SCCM SQL server, the username and password of the user account that the XSOAR engine will use when forming a secure connection with the SQL server, and the name of the SQL database.

Cortex XSOAR Engine Installation

A Cortex XSOAR engine initiates connections to the SCCM SQL server and to the Cortex cloud and provides the means through which they communicate with each other. Although it's possible to install an XSOAR engine on machines running Windows, macOS, and Linux operating systems, only an engine on a Linux machine supports IoT Security integrations. For more information about operating system and hardware requirements, see the Cortex Administrator’s Guide.
We recommend downloading the XSOAR engine using the shell installer script and installing it on a Linux machine. This simplifies the deployment by automatically installing all required dependencies and also enables remote engine upgrades.
When placing an XSOAR engine on your network, make sure it can form a connection to your SCCM SQL server on TCP port 1433 (default port) or whatever custom port has been configured on the SQL server. The XSOAR engine uses this port when authenticating with the SCCM SQL server and exporting device attributes.
In addition, the engine must be able to form HTTPS connections on TCP port 443 to the Cortex cloud at https://<your-domain>.iot.demisto.live/. You can see the URL of your XSOAR instance when you log in to the IoT Security portal and click
Launch Cortex XSOAR
. It’s visible in the address bar of the web page displaying the XSOAR interface.
To create an XSOAR engine, access the Cortex XSOAR interface (from the IoT Security portal, click
Launch Cortex XSOAR
). Click
+ Create New Engine
. Choose
as the type.
For installation instructions, see Install Cortex XSOAR Engines.
For help troubleshooting Cortex XSOAR engines, including installations, upgrades, connectivity, and permissions, see Troubleshoot Cortex XSOAR Engines and Troubleshoot Integrations Running on Engines.

Configure IoT Security and Cortex XSOAR

In Cortex XSOAR, create an integration instance that specifies connection, authentication, and SCCM database settings and create a job that specifies which XSOAR playbook to use to import device information and how often and when to run it. Add more instances and jobs to import device data from multiple SCCM SQL databases.
  1. Log in to IoT Security and from there access Microsoft SCCM settings in Cortex XSOAR.
    1. Log in to IoT Security and then click
      IoT Security uses Cortex XSOAR to integrate with Microsoft SCCM, and the settings you must configure to integrate with it are in the XSOAR interface.
    2. To access these settings,
      Launch Cortex XSOAR
      The Cortex XSOAR interface opens in a new browser window.
    3. If necessary, click
      Servers & Services
      and search for
      in the Settings section to locate it among other instances.
  2. Configure the Microsoft SCCM integration instance.
    1. Click
      Add instance
      to open the settings panel.
    2. Enter the following and leave the other settings at their default values:
      : Use the default name of the instance or enter a new one.
      SQL Server Host/IP
      : Enter the domain name or IP address of the SCCM SQL server.
      SQL Server Port
      : Enter the default TCP port number 1433 or, if a different port number is set on the SQL server, enter that.
      SQL Database
      : Enter the name of the database from which you want XSOAR to retrieve device information.
      Each integration instance can retrieve device information from a single database. If you want to retrieve device information from other databases, you must create additional integration instances for them.
      : Enter the name of the user account you previously configured in the SCCM SQL server.
      : Enter the password associated with the user account.
      Run on Single engine
      : Choose the XSOAR engine that you want to communicate with the SCCM SQL server.
    3. When finished, click
      If the test is successful, a Success message appears. If not, check that the settings were entered correctly and then test the configuration again.
    4. After the test succeeds, click
      Save & exit
      to save your changes.
  3. To enable the Microsoft SCCM integration instance, click
  4. Create a job for XSOAR to retrieve information about devices in the SCCM database specified in the integration instance and then forward it to IoT Security.
    1. Copy the name of the integration instance and open a duplicate browser window.
    2. Navigate to Jobs in the new window, and then click
      New Job
      at the top of the page.
    3. In the New Job panel that appears, enter the following and leave the other settings at their default values:
      Time triggered
      : (select)
      : Select this because you want to periodically import device information from SCCM.
      : Enter a number and set the interval value (Minutes, Hours, Days, or Weeks) and select the days and times on which to run the job. This determines how often and when XSOAR retrieves data from SCCM. Consider running the job every day or every other day at a time when network activity is light, such as late at night, to help reduce potential latency. As a general guideline, it takes approximately 20 minutes for XSOAR to import data for 10,000 devices into IoT Security. You can see the run status of a recurring job on the Jobs page and note how long it takes. When in progress, its status is
      . When done, its status changes to
      : Enter a name for the job.
      : Choose
      Import Microsoft SCCM devices to PANW IoT cloud
      Integration Instance Name
      : Paste the name of the integration instance that you copied earlier.
  5. (
    ) Create more integration instances and jobs to import device information from other SCCM databases into IoT Security.
    To create more integration instances, repeat the previous steps, entering unique names for each one and different settings as appropriate for your SCCM databases.
    For each additional integration instance, create a job for Cortex XSOAR to run, with a similar configuration as the one you initially created. However, as you add more jobs, consider staggering their run times so that the data retrievals are spread out.
  6. Run jobs.
    Run the job for each integration instance you create. The first time you run a job, it triggers XSOAR to report the integration instance that the job references to IoT Security, which then displays the instance on the Integrations page. The integration instance can be in one of the following four states as shown in the Status column on the Integrations page:
    The integration instance can be in one of the following four states, which IoT Security displays in the Status column on the Integrations page:
    • Disabled
      means that either the integration was configured but intentionally disabled or it was never configured and a job that references it is enabled and running.
    • Error
      means that the integration was configured and enabled but is not functioning properly, possibly due to a configuration error or network condition.
    • Inactive
      means that the integration was configured and enabled but no job has run for at least the past 60 minutes.
    • Active
      means that the integration was configured and enabled and is functioning properly.
    When you see that the status of an integration instance has changed from
    , its setup is complete.

Recommended For You