---
title: About Importing Data from SCCM into Neurons for ITSM
slug: neurons-for-itsm/admin-user-help/enu/latest/about-importing-data-from-sccm-into-neurons-for-itsm
createdAt: 2026-07-14T19:16:41.134Z
---
Use this section in conjunction with the information in [Configuring Data Import Connections](docId\:z8kDIsU8GjFwJeWThqcUk).
For on-premises deployments, you *must* install Discovery to use SCCM to import data. For Cloud customers, SCCM uses the Discovery asset processor when importing data.
- [About SCCM](docId\:wJ-L0APc9__VM2qQhsEem)
- [How SCCM Integration Works](docId\:wJ-L0APc9__VM2qQhsEem)
- [Data Imported by the Neurons for ITSM Database](docId\:wJ-L0APc9__VM2qQhsEem)
- [Setting Up the SCCM Integration](docId\:wJ-L0APc9__VM2qQhsEem)
- [Importing Data from SCCM](docId\:wJ-L0APc9__VM2qQhsEem)
- [Mapping SCCM Fields](docId:9GhLdOsFUeOcev7EET03Z)
## About SCCM
You can import data from your Microsoft System Center Configuration Manager (SCCM) database into a Neurons for ITSM configuration management database. This is a one-way import of data. Once you have mapped the fields, you can import data on a scheduled basis.
The configuration management database is a database that stores configuration records of configuration items. In Neurons for ITSM, all configuration item records are stored in the Neurons for ITSM database. A configuration item can be anything such as an asset, service component, or other item that is controlled by configuration management. Inventory management manages the service assets and configuration items to support the other service management processes.
Although Ivanti has not officially certified SCCM 2012, we consider it to be compliant with Neurons for ITSM, assuming that it is backward compatible from the vendor to the certified version.
## How SCCM Integration Works
When you create the connection between the SCCM and Neurons for ITSM databases and map the fields, the Data Integration Wizard automatically imports the data from the SCCM database into the Neurons for ITSM database. You can schedule this import operation to occur periodically.
Each time the data is imported, it is automatically mapped directly into Neurons for ITSM. No other plug-ins or applications are required.
## Data Imported by the Neurons for ITSM Database
By default, the Neurons for ITSM database imports the following information from SCCM data objects. The application is flexible, however, and you can define other objects.
| Source SCCM | Method | Target |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------- | --------------------------------------------------------------- |
| DateTimeNow | --> | Audit TimeStamp |
| SCCM | --> | Identity Property.ScanMethod |
| Computer\_System\_DATA.AgentID | --> | Identity Property.AgentVersion |
| Computer\_System\_DATA.MachineID
Computer\_System\_DATA.InstanceKey | AssetIdentifier | Identity Property.ClientID |
| Computer\_System\_DATA.Description0 | --> | Identity Property.DeviceDescription |
| Computer\_System\_DATA.Domain0
Computer\_System\_DATA.Name0 | Concat | Identity Property.FullyQualifiedDomainName |
| Computer\_System\_DATA.Domain0 | --> | Identity Property.DomainName |
| Computer\_System\_DATA.Name0 | --> | Identity Property.HostName |
| Network\_DATA.IPAddress0
Network\_DATA.IPEnabled00
1 | Select | Identity Property.IPaddress |
| Network\_Data.IPSubnet0
Network\_Data.IPEnabled00
1 | Select | Identity Property .SubnetMask |
| Network\_Data.IPSubnet0
Network\_Data.IPEnabled00
1 | Select | Identity Property.MACaddress |
| PC\_BIOS\_DATA.SerialNumber00 | --> | Identity Property.SerialNumber |
| Computer\_System\_DATA.UserName0 | --> | Identity Property.UserName |
| System\_Enclosure\_DATA.ChassisTypes00 | --> | ComputerSystem Property.ChassisType |
| Physical | --> | ComputerSystem Property.ExecutionEnvironment |
| Computer\_System\_DATA.Manufacturer00 | --> | ComputerSystem Property.Manufacturer |
| Computer\_System\_DATA.Model0 | --> | ComputerSystem Property.Model |
| Operating\_System\_DATA.Caption0 | --> | ComputerSystem Property.OperatingSystem |
| Operating\_System\_DATA.Caption0 | --> | ComputerSystem Property.OSEdition |
| Operating\_System\_DATA.Version0 | --> | ComputerSystem Property.MajorVersion |
| Operating\_System\_DATA.Version0 | --> | ComputerSystem Property.MinorVersion |
| Operating\_System\_DATA.BuildNumber0 | --> | ComputerSystem Property.BuildNumber |
| Processor\_DATA.Name0
Processor\_DATA.Status0
OK | Select | ComputerSystem Property.CPUArchitecture |
| Computer\_System\_DATA.Roles0
LM\_Server
Server
Server\_NT
Server
SQLServer
Server
LM\_Workstation
Workstation
Workstation | CIType | ComputerSystem Property.CIType |
| Computer\_System\_DATA.Roles0
Computer\_System\_DATA.Model0
.\*Virtual.\*
LM\_Server > Server
Server\_NT > Server
SQLServer > Server
LM\_Workstation > Workstation | CIType2 | ComputerSystem Property.CIType |
| Logical\_Disk\_DATA.Size0 | Sum | ComputerSystem Property.TotalDiskSpace |
| Logical\_Disk\_DATA.FreeSpace0 | Sum | ComputerSystem Property.FreeDiskSpace |
| Computer\_System\_DATA.NumberOfProcessors | --> | ComputerSystem Property.CPUCount |
| Operating\_System\_DATA.CSDVersion0 | --> | ComputerSystem Property.ServicePack |
| Network\_DATA.InstanceKey | --> | Category.Component.Property-Hardware.NetworkAdapter.ID |
| Network\_DATA.IPAddress0 | --> | Category.Component.Property-Hardware.NetworkAdapter.IPAddress |
| Network\_DATA.IPEnabled00 | --> | Category.Component.Property-Hardware.NetworkAdapter.IPEnabled |
| Network\_DATA.MACAddress0 | --> | Category.Component.Property-Hardware.NetworkAdapter.MACaddress |
| Network\_DATA.IPSubnet0 | --> | Category.Component.Property-Hardware.NetworkAdapter.SubnetMask |
| Logical\_Disk\_DATA.InstanceKey | --> | Category.Component.Property-Hardware.LogicalStorage.ID |
| Logical\_Disk\_DATA.DeviceID0 | --> | Category.Component.Property-Hardware.LogicalStorage.DiskNumber |
| Logical\_Disk\_DATA.Description0 | --> | Category.Component.Property-Hardware.LogicalStorage.Description |
| Logical\_Disk\_DATA.FileSystem0 | --> | Category.Component.Property-Hardware.LogicalStorage.Format |
| Logical\_Disk\_DATA.FreeSpace0 | --> | Category.Component.Property-Hardware.LogicalStorage.FreeSpace |
| Logical\_Disk\_DATA.Size0 | --> | Category.Component.Property-Hardware.LogicalStorage.Size |
| PC\_BIOS\_DATA.InstanceKey | --> | Category.Component.Property-Hardware.BIOS.ID |
| PC\_BIOS\_DATA.ReleaseDate0 | --> | Category.Component.Property-Hardware.BIOS.Date |
| PC\_BIOS\_DATA.Manufacturer0 | --> | Category.Component.Property-Hardware.BIOS.Manufacturer |
| PC\_BIOS\_DATA.Version0 | --> | Category.Component.Property-Hardware.BIOS.Version |
| Processor\_DATA.InstanceKey | --> | Category.Component.Property-Hardware.Processor.ID |
| Processor\_DATA.Name0 | --> | Category.Component.Property-Hardware.Processor.ProcessorName |
| Processor\_DATA.NormSpeed00 | --> | Category.Component.Property-Hardware.Processor.Manufacturer |
## Setting Up the SCCM Integration
Neurons for ITSM currently supports SCCM Release 2007. The data flow from SCCM to Neurons for ITSM is unidirectional.
The connection from the integration server can be either through your VPN or through the internet with or without SSL encryption for the SCCM database server connection.
Before attempting to make the connection, ensure the following:
- SCCM is running.
- Your firewall is open for the Microsoft SQL server connection, for either the Internet or a VPN.
The default port for the Microsoft SQL server connection is TCP/IP port 1433. However, you can set up any TCP/IP port.
To enable encrypted connections to the Microsoft SQL server, refer to [http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx](http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx).
## Importing Data from SCCM
- [Getting Started](docId\:wJ-L0APc9__VM2qQhsEem)
- [Object Mapping](docId\:wJ-L0APc9__VM2qQhsEem)
- [Filter Manager](docId\:wJ-L0APc9__VM2qQhsEem)
- [Field Mapping](docId\:wJ-L0APc9__VM2qQhsEem)
### Getting Started
To import data from SCCM into Neurons for ITSM, follow these steps:
1. Perform steps 1 to 5 in the section called [Setting Up a Data Import Connection](docId\:z8kDIsU8GjFwJeWThqcUk).
2. In step 5, select **SCCM**.
3. Enter information into the fields.
| Field | Description |
| -------------- | ---------------------------------------------------------- |
| Server Name | The name of the server where the SCCM database is located. |
| SSL Encryption | Specifies if the server supports SSL encryption. |
| Database Name | Name of the SCCM database. |
4. Proceed to [Object Mapping](docId\:wJ-L0APc9__VM2qQhsEem).
### Object Mapping
1. Enter information into the fields.
| Field name | Description |
| ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Mapping | The default mapping. Select the default or select **Add New** from the drop-down list. |
| Name | The mapping name. Use the default name, modify the name, or enter a new name for the mapping. To modify the existing name or add a new name, click **Save as New**. |
| Max file size | Read only. Shows the maximum file size that you can import. The maximum file size is 50 MB. |
| Source File Name | Read only. Taken from the value in the **File Name** field. |
| Source Mapping Objects | The source mapping objects. Select all objects that should be included. Ensure that Computer\_System\_Data is selected. |
| Batch size | Specifies the number of records that should be retrieved each time the database is queried. The default is 200. Do not make this number too small as it could cause excessive database activity. |
| Max size | Specifies the total number of records to process for any given job. |
| Root Table | The table that contains records that uniquely identify the computer systems in your organization. Keep the default as Computer\_System\_DATA. This is the top-level object, which is equivalent to the configuration item business object in the Neurons for ITSM database. |
| Unique Key | The field that contains the key that uniquely identifies a computer record. This is essentially the primary key, which can be used to retrieve additional information about a computer. |
| Change-Time column | The date and time when a record is updated. Select **TimeKey**. |
2. Proceed to [Filter Manager](docId\:wJ-L0APc9__VM2qQhsEem).
### Filter Manager
1. To view the column values of a SCCM database schema, run a Microsoft SQL query.
:::Paragraph{indent="1"}
For example, to get the values for the **Roles0** column from the **Computer\_System\_Data.Roles0** root table, enter the query: **Select distinct Computer\_System\_DATA.Roles0, \*from Computer\_System\_DATA**.
:::
:::Paragraph{indent="1"}
The application displays the following results:
:::
*Sample Mapping Results*
::Image[]{src="https://api.archbee.com/api/optimize/parib0MC3hVoUNdfQdnac/yt2r6QFHft3x-H65vBnXR_sccmsqlresults.png" alt="Sample mapping results." position="flex-start" size="40" initialPath="../../Resources/Images/help-images/sccm_sqlresults.png" githubPath="Content/Resources/Images/help-images/sccm_sqlresults.png" showCaption="false" indent="1"}
*SCCM Filter Manager*
::Image[]{src="https://api.archbee.com/api/optimize/parib0MC3hVoUNdfQdnac/3RIMkcN997S42qd19GTq8_filtermanager.png" alt="Image of the SCCM Filter Manager." position="flex-start" size="40" initialPath="../../Resources/Images/help-images/filter_manager.png" githubPath="Content/Resources/Images/help-images/filter_manager.png" showCaption="false" indent="1"}
2. Proceed to [Field Mapping](docId\:wJ-L0APc9__VM2qQhsEem).
### Field Mapping
For additional information about field mapping, refer to [Mapping SCCM Fields](docId:9GhLdOsFUeOcev7EET03Z)
After setting up the filters for the table rows, map the fields and transformation. The first five mapped fields are required. Do not delete these.
1. If appropriate, select a transformation function from the middle column or leave it as is.
2. Select the field names to map between SCCM and Neurons for ITSM.
:::Paragraph{indent="1"}
The left column shows the fields from the root table column Computer\_System\_DATA.Roles0, which was selected on the previous page. The right column shows the asset identity of the matching fields in Neurons for ITSM.
:::
3. Proceed to [Setting the Data Import or Web Service Connection Schedule](docId\:z8kDIsU8GjFwJeWThqcUk).