Service Manager

Mapping SCCM Fields

•About SCCM Field Mapping

•Example 1: Mapping CI Type

•Example 2: Mapping CI Type

•Example 3: Switch Function

•Example 4: Mapping Type AssetIdentifier to Serial Number

About SCCM Field Mapping

The asset identifiers and their mapped fields are stored in the Asset Data Mapping workspace. This workspace controls how incoming asset data gets processed by the asset processor and to which business object this data is mapped.

1.Log into the Service Manager Application.

2.Open the Asset Data Mapping workspace. A list of business objects defined for the configuration item appears.

3.Double-click the configuration item business object to which to map the SCCM field, such as CI.Workstation. The Asset Data Mapping page appears.

4.Select the Field Mappings tab. The list of asset identity or property appears on the SCCM Configuration Field Mapping page and on the corresponding field name on the asset data mapping record.

Asset Data Mapping Example

Example 1: Mapping CI Type

The SCCM row for Computer_System_Data.Roles0 contains the data:

LM_Workstation, LM_Server, SQLServer, Backup_Domain_Controller, Timesource, Print, NT, Backup_Browser, Master_Browser, DFS

The mapping is defined in pairs, except the last value.

Value	Paired With
LM_Server	Server
Server_NT	Server
SQLServer	Server
LM_Workstation	Workstation
Workstation	If no match, uses this default value

Field Mapping Example - Configuration Items

The first match of the Value column above is mapped to the value in the Paired With column and is saved as the CI.Type.

In this example, the CI.Type is "Server" since there is a match in the Roles0 value for "LM_Server".

If role = LM_Workstation, returns Workstation.

If role = SQLServer, returns Server.

If role is not defined or does not exist, the default value is Workstation.

Example 2: Mapping CI Type

The SCCM row for Computer_System_Data.Roles0 contains the following data:

LM_Workstation, LM_Server, SQLServer, Backup_Domain_Controller, Timesource, Print, NT, Backup_Browser, Master_Browser, DFS

The SCCM row for Computer_System_Data.Model0 contains the Virtual Model Regex pattern data.

The mappings are defined as shown.

Value	Paired With
LM_Server	Server
Server_NT	Server
SQLServer	Server
LM_Workstation	Workstation

CIType2 Field Mapping Example - Configuration Items

The first match of the Value column above is mapped to the value in the Paired With column and is saved as the CI.Type.

If the Model Regex pattern matches the Model0 value, the application prepends the word "Virtual" to the previously identified CIType. Therefore, if a pattern match occurs for LM_Server, then the final CIType is VirtualServer.

If role = LM_Workstation, the CIType match is Workstation.

If role = SQLServer, the CIType match is Server.

If role is not defined or does not exist, the default value assigned is the last defined CIType, in this case, Workstation.

Example 3: Switch Function

The switch structure is built on the usual switch/case statement structure. The last entry acts as default.

Pseudo Code Example

switch (VirtualMachineType)

case '1': ExecutionEnvironment = Physical

case '2': ExecutionEnvironment = VMWare

case '3': ExecutionEnvironment = Virtual

1.In the SCCM tool, add a switch by selecting the + icon.

2.At the initial drop-down list, select database fields to map the source and target in the drop-down lists.

3.Add switch case information for as many items as needed, as shown below. For example 2:VMWare. If the mapping finds 2 in the Source database field, it enters VMWare within the database field selected in the target.

Field Mapping Example for Switch Function

Example 4: Mapping Type AssetIdentifier to Serial Number

Setting up a mapping from asset identifier type to serial number can be achieved by using the following method. The mapping type asset identifier works by creating a unique string as seen below, which should not be changed: SCCM-<first_8_hex_chars_of_machine_ID>-<rest_of_the_machine_ID_in_hex_chars>-<first_8_hex_chars_of_instance_key>-<rest_of_the_instance_key_in_hex_chars>.

In Discovery, the following criteria are used to match an asset to an existing configuration item in the order listed.

1.Client ID and fully qualified domain name (FQDN)

2.Host name (may not be fully qualified)

3.MAC address

Since serial number is not one of the fields that is used to match, the best way to set this up is to use the host name. This can be achieved by using one of the following two methods:

•Change the field mappings in the import so that the serial number is stored in the host name and vice versa. The issue with this method is that data is stored in fields that are not named correctly.

•Add a new field called NewName to the configuration item business object that has the same properties as the Name field. Add a new asset data mapping to each configuration item business object required to store the host name in this new field (such as Server, Virtual Server, Workstation, and so on.)

Now that a mapping exists to store the host name, change the asset data mapping to store the serial number in the Name field. The forms for the appropriate business objects should also be changed to display the data in the NewName field as the host name and the name data as the serial number.