Creating a basic integration for Microsoft System Center Configuration Manager (SCCM) assets

Let Oomnitza be your single source of truth!

You'll get visibility of all the network devices in your organization as data from SCCM is automatically transformed into consumable information and actionable insights.

Connect Oomnitza and SCCM in minutes

Get the information and the insights that you need to reduce costs and the time that you spend on administration tasks such as:

• Configurable dashboards and list views of key information relating to SCCM managed devices
• Configurable reports to share information about SCCM managed devices with your colleagues and management

About the integration

To stream asset data from SCCM to Oomnitza, you must complete these tasks:

1. Download the source code for the Oomnitza connector
2. Generate a configuration file
3. Edit the configuration file
4. Map SCCM fields to Oomnitza fields
5. Run the SCCM network devices connector
6. Schedule the connector

Before you start

To stream data into Oomnitza, complete these tasks:

1. Review the system requirements. 
2. Download and install Python. Best practice is to create a virtual environment. A virtual environment is created on top of the existing Python installation and can be isolated from the packages in the base environment, so only those explicitly installed in the virtual environment are available.

Installing the connector

GitHub: Getting started

Download the source code for the Oomnitza connector

1. In Oomnitza, click Configuration > Integrations and click Block view
2. In the Basic section for Asset Integrations, click the Microsoft System Center Configuration Manager tile.
3. Download the source code and place it in a directory, such asC:\oomnitza_connector

You can also download the source code on the Oomnitza Connector page on GitHub.

Installing the requirements

In the directory you created (C:\oomnitza_connector), install the required Python dependencies stored in the requirements.txt file usingpip install -r requirements.txt

Tip
Runpip install --upgrade pipbeforehand to install and use the new version of pip

Generate the configuration file

In the same directory, runpython connector.py generate-inito generate theconfig.inifile. For further information read the Connector Configs section in the Getting started document.

Tip
Runpython connector.py --helpto see all available command line options.

To find out more, read the Connector Configs section in the Getting started document.

Edit the configuration file

You must modify the following sections in the configuration file:

• The Oomnitza section
• The SCCM section

Before you edit the configuration file, you must retrieve the following information:   

Your Oomnitza API token can be created in Configuration > Security > API tokens

You SQL Server password and username (optional). Alternatively, you can authenticate using your Windows credentials.

Your SCCM server and database name

1. Open the configuration file that you generated in edit mode.
2. In the Oomnitza section, enter the URL of your Oomnitza instance and enter the API token that you generated in Oomnitza. 
   

   Oomnitza configuration settings 
   [oomnitza]
url= https://<name_of_instance>.oomnitza.com
api token = <my_Oomnitza_token> 

3. In the SCCM section, make the following changes:

   SCCM configuration settings 
   enable = True
   server = The server hosting the SCCM database, i.e. server.example.com
   database = The SCCM database from which to pull data.
   username = The username to use when connecting to the server using SQL Server authentication. This user requires read-only access to the DB. This is not required when using Windows authentication.
   password = The password to use when connecting to the server using SQL Server authentication. This user requires read-only access to the DB. This is not required when using Windows authentication.
   authentication = Sets the type of authentication to use when connecting to the server. Options are SQL Server or Windows. The default is SQL Server Authentication. When using Windows authentication, the username and password fields are ignored and the credentials for the currently logged-in user will be used when making the connection to the SCCM database.
   driver = The driver used to communicate with SCCM database. In most cases it has to be left empty; if left empty the connector will use the most recent driver. In a Windows environment, there should be at least one legacy driver named "SQL Server". In other environments, you may have to explicitly install drivers (download drivers). Please refer to this page for the list of currently supported drivers.

4. You can delete all the other configurations you do not need from the list, i.e. Kace, Jasper etc.
5. Save your changes

Map SCCM fields to Oomnitza fields

To get the information that you need to manage your network devices, complete these actions:

1. In Oomnitza, click Configuration > Integrations and click Block view
2. In the Basic section for Asset Integrations, click the Microsoft System Center Configuration Manager tile.
3. Click Mappings.
4. Map the SCCM fields to the Oomnitza fields.  
5. Select the Serial Number as the sync key, which will synchronize the data that is streamed from SCCM to Oomnitza.
6. Click FINISH.

Custom SCCM mappings

You can map the following fields to Oomnitza:

CPU
Computer Name
Domain Name
IPv4 Address
Is antivirus enabled
Is system drive (C:) encrypted
Last Logged in User
Last logon
MAC Address
Make
Model
OS Version
Platform
Primary User
Resource ID
Serial Number
Total HDD (MB)
Total Memory (KB)

Want to map more SCCM fields to Oomnitza?
Contact Support

Run the SCCM network devices connector

To upload the network device information to Oomnitza, run the connector.

Run the connector in test mode to ensure that the mapped information is uploaded to Oomnitza:

python connector.py upload sccm --testmode

When you are confident that you are uploading the information that you mapped, run the connector again in normal mode:

python connector.py upload sccm

1. Click Configuration > Integrations and click Block view
2. In the Basic section for Asset Integrations, click the SCCM Network Devices tile.
3. Click SYNC SESSIONS.
4. Go to the Assets page and review the information that is uploaded.

Schedule the connector

Finally, you'll need to manage the scheduling of your basic integration on your local machine (using tools such as Task Scheduler for example).

For information on setting a connector schedule, refer to the Scheduling the connector section in the below documents:

Installing the Oomnitza connector on a Ubuntu machine

Installing the Oomnitza connector on a Windows machine

Installing the Oomnitza connector on a Mac OS X machine

Unleash the power of Oomnitza

To get valuable actionable insights that help you manage your assets, learn how to:

• Configure dashboards for your assets
• Configure custom reports about your assets 

See Getting started.