About Importing Data from SCCM into ISM

Use this section in conjunction with the information in Data Import Connections.

For on-premise deployments, you must install Discovery to use SCCM to import data. For Cloud customers SCCM used the Discovery asset processor when importing data.

About SCCM

How the SCCM Integration Works

Data Imported by the ISM Database

Setting Up the SCCM Integration

Importing Data from SCCM

Mapping SCCM Fields

About SCCM

You can import data from your Microsoft System Center Configuration Manager (SCCM) database into a Service Manager 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 Service Manager, all configuration item records are stored in the Service Manager 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 Service Manager, assuming that it is backward compatible from the vendor to the certified version.

How the SCCM Integration Works

When you create the connection between the SCCM and Service Manager databases and map the fields, the Data Integration Wizard automatically imports the data from the SCCM database into the Service Manager database. You can schedule this import operation to occur periodically.

Each time the data is imported, it is automatically mapped directly into Service Manager. No other plug-ins or applications are required.

Data Imported by the ISM Database

By default, the Service Manager 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

Service Manager currently supports SCCM Release 2007. The data flow from SCCM to Service Manager 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 Internet or 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, see http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx.

Importing Data from SCCM

Getting Started

Object Mapping

Filter Manager

Field Mapping

Getting Started

To import data from SCCM into Service Manager, follow these steps:

1.Perform steps 1 to 5 in the section called Setting Up a Data Import Connection.

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.

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 Service Manager 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.

Filter Manager

1.To view the column values of a SCCM database schema, run a Microsoft SQL query.

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.

The application displays the following results:

Sample Mapping Results

SCCM Filter Manager

2.Proceed to Field Mapping.

Field Mapping

For additional information about field mapping, see Mapping SCCM Fields

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 Service Manager.

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 Service Manager.

3.Proceed to Setting the Data Import or Web Service Connection Schedule.