Data Import Connections

Before you configure any Data Import Connections, make sure that the Asset Processor Configuration is defined. For more information, refer to Asset Processor Configuration.

Use the Data Integration Wizard to import data from a predefined source into the Service Manager database.

Viewing, Cloning, and Deleting Data Import Connections

Setting Up a Data Import Connection

Object Mapping

Setting Filter Conditions

Mapping Fields

Setting the Data Import or Web Service Connection Schedule

Reviewing and Publishing Import or Web Service Connection Data

Troubleshooting

Example: Importing Configuration Item Relationships

Viewing, Cloning, and Deleting Data Import Connections

1.From the configuration console, click Extend > Integration Tools > Data Import Connections to open the Data Source Manager page.

Data Source Manager

The Data Source Manager page has the following fields:

Field Description
Name The name of the data import connection.
Connector

The connection import type:

SCCM

Email import

Simple file import (FTP, file)

Advanced file import (Secure FTP, hierarchical XML)

Discovery (for Release 9.3.x and later)

Connection Source Source information such as server name and database name (for SCCM and Discovery Release 9.3.x and later) or server path and file name (for FTP and file).
-- Contains details about when the data import connection was created and last modified.
Active Specifies if the connection is active or not. Only published connections can be active. To activate the data import connection, click ON. To deactivate the data import connection, click OFF.
Published Specifies if the data import connection is published.
Mapping The name of the integration job.

2.To clone a data import connection, including all of its mappings and schedules, do the following:

a. Click the clone icon at the end of the row.
b. In the confirmation message, click OK.

The new data import connection appears in the list as unpublished.

3.To delete a data import connection, do the following:

a. Click the delete icon at the end of the row.
b. In the confirmation message, click OK.
c. If there are any mappings associated with this data import connection, a second confirmation message appears.  Click OK.

The data import connection is no longer displayed.

4.To submit the integration job to be executed by the integration server, do the following:

a. Click Run Now at the end of the row.
b. In the confirmation message, click Yes.

For a manual upload, the application prompts you to upload the file before submitting the job.

Setting Up a Data Import Connection

Use this process to set up a connection to the server where the data is located.

If you import data on a schedule, the options are defined in the Schedule Entry workspace. See About the Schedule Entry and Scheduled Jobs Workspaces for more information. For example, for Endpoint Manager Integration, define a daily CMDB import schedule using the Schedule Entry Workspace before selecting it on the Import wizard. The schedule setting option only appears if Discovery 9.x, File on Shared Folder, FTP, SCCM, (EPM, Secure FTP (SSH), or Ivanti Cloud Connector is selected as the connection type, or if you create a new web service connection. The basic steps shown below, are followed by specific set ups for different connectors.

Data Import Setup Sequence -- Connection Setting

1.From the configuration console, click Extend > Integration Tools > Data Import Connections, to open the Data Source Manager page.

The page lists all the connections that are already defined for your installation.

2.Click Add New... to add a new connection and to open the Settings page.

Connection Settings Page

3.In the Connection Name field, enter a unique name for the connection.

4.Select a Connection Type from the drop-down list:

Email Import. See Email Import.

Discovery 9.x. (Only applicable for Discovery Release 9.3.x and later). See Ivanti HEAT Discovery File.

File on Shared Folder. See File on Shared Folder. (File share is only available for on-premise deployments.)

FTP. See FTP Connection Type.

Manual File Upload. See Manual File Upload.

SCCM. See About Importing Data from SCCM into ISM.

Secure FTP (SSH). See Secure FTP (SSH)

EPM. See Endpoint Manager (EPM) Connector.

Ivanti Cloud Connector. See Feature Preview: Ivanti Cloud Connector.

Email Import

Select this option to import data from an email message.

Continue to Enter information about the specific file. Select the file type to import:

Ivanti HEAT Discovery File

Select this option to import data from a Discovery Release 9.3.x and later database.

a. Enter information into the fields.
Field Description
Connection Name

The connection name.  Always use Discovery 9.x. Do not change the name unless you are setting up a new configuration or modifying this one for your import.

SSL Encryption Specifies if the connection uses SSL encryption.
Server Name

The server path, such as Servername or IP Address, where the database is located.

Database Name The database name. Enter Ivanti HEAT Discovery.
b. Continue to Importing Data from Ivanti HEAT Discovery Release 9.3.x or Later to set the object mapping, field setting, field mapping, and schedule settings.

File on Shared Folder

File share is only available for on-premise deployments.

Select this option to import data from a shared network file.

a. Enter information into the fields.
Field Description
Data File Name

The name of the data file. See About Importing Multiple Files for information about using the * wildcard to import multiple files at once.

Template File Name

Optional. The name of the file that is a subset of the mapping file.

If your mapping file is large, you might want to create a smaller file containing only the columns or fields for mapping, to create a map before data import.

b. Continue to Enter authentication information if required.

FTP Connection Type

Select this option to connect to a file server (not a web server) to transfer data. The FTP protocol is used to upload files from a workstation to a specified FTP server.

a. Enter information into the fields.
Field Description
SSL Encryption Specifies if the connection uses SSL encryption.
Active Mode FTP supported mode. By default, this is set to passive mode (that is, this box is not checked). To enable Active mode, check the box.
Data File Name

The name of the data file.

Template File Name

Optional. The name of the file that is a subset of the mapping file. If your mapping file is large, you might want to create a smaller file containing only the columns or fields for mapping, to create a map before data import.

b. Continue to Enter authentication information if required.

Manual File Upload

Select this option to create a non-scheduled one-time data import. You can import data from a local file source into your database. This import configuration can be saved to your list of integration connections, but cannot be scheduled, due to the nature of a manual import. You must manually import the data file each time you run the connection.  Supported file types are .CSV, .XLS, and .XML

a. Enter information into the fields.
Field Description
Data File Name

The name of the data file.

See About Importing Multiple Files for information about using the * wildcard

to import multiple files at once.

b. Continue to Enter information about the specific file. Select the file type to import: 

Secure FTP (SSH)

Select this option to connect to a secure file server (not a web server) to transfer data. The Secure FTP protocol is used to upload files from a workstation to a specified secure FTP server.

a. Enter information into the fields.
Field Description
Data File Path

The path of the data file.

Template File Path Optional. The path of the file that is a subset of the mapping file. If your mapping file is large, you might want to create a smaller file containing only the columns or fields for mapping, to create a map before data import.
b. Continue to Enter authentication information if required.

Endpoint Manager (EPM) Connector

Select this option if you are using Ivanti Endpoint Manager (EMP) and you want to import data from the Endpoint Manager database into Ivanti Service Manager.

a. Enter information into the fields.
Field Description
Server Name

The name or the IP address of the server where the Endpoint Manager data is located.

Database Name

Use the default of EPM.

b. Enter authentication information as seen in Enter authentication information if required. ,
c. Next, test the connection: Test the data import connection . As specified, do not click Close or move to the next step until the connection test is successful.
d. If the connection is successful, click Close then click Next to specify Object-level Mappings. See Object Mapping and Mapping Fields for Import. When creating a mapping for this connector, select EPM Connector from the drop-down.

Use the wizard to identify the next step in the process to map fields or objects, use transitions, and to schedule your import.

Use the following steps only as indicated by the Connector.

5.Enter authentication information if required.

Field Description
Use global constants for login and password Specifies if the login and password information are global constants. If you check this option, you must create the login and password global constants before you can use them. See Using Global Constants to Hide Login ID and Password Information.
Login

The login ID used to access the server.

Enter a value if you did not check Use global constants for login and password.

Select a value from the drop-down list if you checked Use global constants for login and password).

Password

The password used to access the server.

Enter a value if you did not check Use global constants for login and password.

Select a value from the drop-down list if you checked Use global constants for login and password).

6.Enter information about the specific file. Select the file type to import:

Comma Delimited (CSV)

Excel Spreadsheet (XLS, XLSX)

XML

Hierarchical XML

Comma Delimited (CSV)

This format can be read by most applications, such as Microsoft Word or Microsoft Excel. This format does not support line breaks.

Do not include commas within the data of the last column of your CSV file. CSV treats a comma within quotes as a separator if it is in the last column.

For example: "Initials", "mail", "telephoneNumber", "givenName", "company", "Wilma", "wasselt", "Asselt, van"

The last field is lastName with the format of "Asselt, van". If this field is not the last column, then the data import is able to import it correctly as "Asselt, van". However, when it is in the last column, the data import only sees "Asselt" and not the data after the comma.

Field Description
Delimiter

The field delimiter. Do one of the following:

Select an option from the drop-down list:

Comma (,)

Colon (:)

Semicolon (;)

Enter a custom value.

Excel Spreadsheet (XLS, XLSX)

This format can be read by Microsoft Excel or other compatible applications. You can only import a single-page Microsoft Excel worksheet.

About Multiple Role Support for CSV and XLS files

Add a Role column to the input file that contains the role display names. If you are updating an existing employee record during the upload, any new roles are added to the roles already assigned to the employee in the employee record.  The application separates roles by commas.

The Role column should be named *Role* (with the asterisks included) and should include the role display name and not the actual role name. For example, include Self Service and not SelfService. All role names should be in the column and separated by commas.

The application does not add roles. The role must already exist before it can be assigned to an employee.

By default, it is always merge behavior.  For example, if an employee already has two roles (for example, Service Desk and IT),and we assign three roles in the import (for example, IT, admin, and service owner), the end result is four roles (Service Desk, IT, admin, and service owner).

XML

Imports generic XML data.

Field Description
Table Element The name of the table object.
Row Element The name of the row object.
Include Header Row

Inputs an XML file in legacy GBU format. In this format, the table element is "Rows", and row element is "Row".

<Rows>
    <Row>
        <Field>PrimaryEmail</Field>
        <Field>FirstName</Field>
         ...
    <Row>
<Rows>

Do not check this option to use the flexible two-level format.

In this example,the table element is "Employee_Info", and the row element is "Employee". The field names for this "Employee" object can be an element (such as Name) or a row-level attribute (such as Employee_Number).

<Employee_Info xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="employee.xs">

    <Employee Employee_Number="105">

        <Name>Masashi Okamura</Name>

        <Department>Design Department</Department>

         ...

    </Employee>
</Employee_Info>

Data with null values do not appear in the XML file, which can cause problems when exporting data.

For example, consider the following XML. Note the data for the second employee contains an email cell with no attributes. This cause the data to import incorrectly.

<Employee_Info>
    <Employee Employee_Number="105">
        <Name>Masashi Okamura</Name>
        <Department>Design Department</Department>
         <Email>[email protected]</Email>
        <Phone>408.555.1234</Phone>
    </Employee>
    <Employee Employee_Number="106">
        <Name>Frank Smith</Name>
        <Department>Design Department</Department>
         <Email></Email>
        <Phone>408.555.1235</Phone>
    </Employee>
</Employee_Info>

To alleviate this issue, create an empty string:

<Employee_Info>
    <Employee Employee_Number="105">
        <Name>Masashi Okamura</Name>
        <Department>Design Department</Department>
         <Email>[email protected]</Email>
        <Phone>408.555.1234</Phone>
    </Employee>
    <Employee Employee_Number="106">
        <Name>Frank Smith</Name>
        <Department>Design Department</Department>
         <Email>""</Email>
        <Phone>408.555.1235</Phone>
    </Employee>
</Employee_Info>

Hierarchical XML

Imports a structured XML file.

Field Description

Table Element

Row Element

Include Header Row

These options are disabled because the values are automatically picked up by the XML file.
Main XSLT

Optional. Defines a template to apply to your XML file.

Click Upload and navigate to your template file.

Additional XSLT Click to add additional XSLT files.

See also Importing Hierarchical XML Data.

Large files (over 50 MB) take longer to preview, because the entire file is downloaded before the first batch can be shown. In other types, the copy/download occurs when moving from the connection to the object mapping page. In hierarchical XML, the application bypasses all mapping pages. Hence, the copy/download only occurs when a user wants to preview the file.

Enter hierarchical information into the fields.
Field Description
Decimal separator

The decimal separator symbol. Enter a value or choose one from the drop-down list.

Encoding

The character standard of your file. Select from the drop-down list.

Date Format
Time Format
Time Zone

The date, time, and time zone format of your file. Select values from the drop-down lists.

This ensures that your data is imported correctly into the database.

If your data does not contain date or time fields, use the default settings.

Test the data import connection

1.Click Test Connection.

If your connection is set up correctly, the application displays a success confirmation message and updates the connection date and time.

If the connection fails, do not click Next until the test connection shows the success message. The connection could fail because of various reasons such as incorrect authentication, restricted or no FTP access, or restricted file permissions.

2.Click Next.

Depending on the data import connection type, the next page in the Data Integration Wizard appears.  The next page is as follows:

Connection Type Additional Pages
Email Import

none

Discovery 9.x

(only for Discovery Release 9.3.x and later)

Object Mapping

Filter Setting

Field Mapping

Schedule Setting

Review and Publish

File on Shared Folder

(Only available for on-premise deployments)

Object Mapping

Filter Setting

Field Mapping

Schedule Setting

Review and Publish

FTP

Object Mapping

Filter Setting

Field Mapping

Schedule Setting

Review and Publish

Manual File Upload

Object Mapping

Filter Setting

Field Mapping

Review and Publish

SCCM

See About Importing Data from SCCM into ISM.

Secure FTP (SSH)

Object Mapping

Filter Setting

Field Mapping

Schedule Setting

Review and Publish

EPM Connector

Object Mapping

Filter Setting

Field Mapping

Schedule Setting

Review and Publish

Object Mapping

Data Import Setup Sequence -- Object Mapping

1.Enter information into the fields. Some fields do not appear on all options.

Field Description
Mapping The mapping. Select the default mapping or select Add New from the drop-down list.
Name

The mapping name. Use the default name, modify the name, or choose Add New from the drop-down list to create a new mapping. To modify the existing name, click Save as New. The application creates a clone of the mapping, which you can then modify. This button is only enabled if you select an existing mapping.

Source Mapping Tables For EPM Connector
Max file size Read only. Shows the maximum file size that you can import. The default maximum file size is 250 MB.
Max size For EPM Connector: Enter the number of records that should be retrieved each time the database is queried.
Root Table For EPM Connector: Select the table that contains the records which can uniquely identify the computers or other machines in your organization.
Source File Name Read only. Taken from the value in the File Name field.
Source Unique Key/Unique Key Lists the fields containing keys that uniquely identify your record. The fields that appear in the list are taken from the first record in your source file. Select the field that is primary in identifying your records, which can be used to retrieve additional information.
Change Time column

For EPM Connector: Select TimeKey this records the time when a record is updated. Keep the default Computer since this is a top-level object equivalent to the CI Business object in IS

Target Business Object

The primary business object in Service Manager into which the data is imported. Highlight the business object in the list.

 

The list shows all the business objects in Service Manager. Use the Target Business Object field to enter a few letters of the target business object and then click Filter by Name or Filter by Object to narrow your search. For example, if you are importing a list of employee records into Service Manager, the primary business object you need to map to is the Employee business object.

2.Click Next. The application displays the Filter Setting page.

Setting Filter Conditions

Data Import Setup Sequence -- Filter Setting

After mapping the business object tables to query, you can optionally specify filter conditions for the root business object.

1.Click Create Filter. The filter fields appear. If the Create Filter button is not visible, delete the default mappings on the previous page.

2.Select a condition.

3.Enter the fields and operators into the form.

Filter Manager Conditions and Fields

4.Click the add icon to add another row.

Mapping Fields

Mapping Fields for Import

About Transformation Functions

About Mapping Link Fields

About Mapping Files with Currency Data

Mapping Fields for Import

Data Import Setup Sequence -- Field Mapping

Use this page to define the field level mapping and transformation. The left column shows the source file name and the right column shows the target business object field name. It is assumed that the Source mapping names are known or identified in advance.

For Endpoint Manager (EPM) The first 5 field mappings: Audit.TimeStamp, Audit.RequestID, Audit.FirstSequence, Audit.LastSequence. Audit.Type are required.

Map Fields for Import

1.If appropriate, select a transformation function from the middle column. See About Transformation Functions for a list of the transformation functions.

2.Select the field names to map between the source file and the target business object in Service Manager.

For example: an EPM Connector (EPM) field CompSystem.Manufacturer would map to the ISM ComputerSystem.Property.Manufacturer asset identifier.

3.If the target field is a link field, determine the name of the field to use.  See About Mapping Link Fields.

4.(Optional) Click Auto Map to map the source file column header to the target field name. Remapping the source column header does not change your existing mapping.

5.Click Next. The application displays the Schedule Setting page or the Review and Publish page.

About Transformation Functions

The following table lists the transformation functions.

Function Name

Category

Description

Input

Output

-->

None

Returns the source value (does nothing).

   
Abs Math The absolute value of input value. Double Double

AssetIdentifier

Special

Creates a unique identifier from the SCCM or EPM Connector machine ID and

the instance key.

SCCM machineID

SCCM InstanceKey
EPM machineID

 
Avg Math The arithmetic mean or average of all the input values. Double Double
Cbrt Math The cube root of the input value. Double Double

Ceiling

Math

Smallest integer value less, greater than, or equal to the given value.

Double

Double

Century DateTime Returns the century part of the input date time value. DateTime Double

CIType

Special

Returns configuration item types from the SCCM or EPM mappings and role.

See Example 1: Mapping CI Type.
For EPM, mapping examples are:

If role = SQLServer, return Server

If role=not defined or does not exist, return default value Computer

If role=LM_Workstation, return Workstation.

SCCM Mapping and Role

EPM Mapping and role.

 
CIType2 Special

Returns configuration item types from the SCCM mappings, role, model and virtual keywords.

See Example 1: Mapping CI Type.

SCCM Mapping and Role
EPM Mapping
 

Concat

String

Concatenates string values together.

String Array

String

ConvertToLocal

DateTime

Converts a DateTime value to a local DateTime value.

DateTime

DateTime

ConvertToUTC

DateTime

Converts a DateTime value to a UTC DateTime value.

DateTime

DateTime

DateTimeNow

DateTime

Current date and time in yyyy-MM-ddThh:mm:ss format.

None

String

DateTimeUTCNow

DateTime

Current UTC date and time in yyyy-MM-ddThh:mm:ss format.

None

String

DayOfMonth DateTime Returns the day of the month of the input DateTime value. DateTime Double
DayOfWeekNo DateTime

Returns the day number of the week of the input DateTime value.

0: Sunday

1: Monday

2: Tuesday

3: Wednesday

4: Thursday

5: Friday

6: Saturday

DateTime Double
DayOfWeekStr DateTime

Returns the day string of the week of the input DateTime value.

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

DateTime String
DayOfYear   Returns the day of the year of the input DateTime value. DateTime Double

Diff

Math

Subtracts all the values from the first value.

Double Array

Double

Div

Math

Divides the first value by the remainder of the values.

Double Array

Double

Floor

Math

Largest integer value less, greater than, or equal to the given value.

Double

Double

Hour DateTime Returns the hour part of the input DateTime value. DateTime Double
IsoWeek DateTime Returns the ISO week number of the input DateTime value. DateTime Double
Leap        
Length String The length of the string. String Double
Max        
Min        
Minute DateTime Returns the minute part of the DateTime value. DateTime Double

Mod

Math

Remainder after dividing first value by the second value.

Double,

Double

Double

Month DateTime Returns the month part of the input DateTime value. DateTime Double
Pow Math The number raised to the power. Double Double

Product

Math

Product of all values.

Double Array

Double

Quarter DateTime Returns the quarter of the input DateTime value. Quarter ranges from 1 to 4. DateTime Double
RegexMatch String Returns a matched value from the input value for a pattern in a position (zero-based). String  
RegexReplace String Returns a string that has been replaced with a string that matches a pattern in the input string. String  

Replace

String

Replaces the part of a string with given value.

String

String

Round

Math

Rounds a double-precision floating-point value to the nearest integer.

Double

Double

Second DateTime Returns the second part of the DateTime value. DateTime Double

Select

Special

Return the first item in the list where the corresponding predicate is equal to a given value.

 String  String
SelectNotNull Special Returns the first input value that is not empty or not null for the group of items. String String

SelectSort

Special

Returns the first item in the list after sorting by the SortField on SortValue; Asc for ascending order and Desc for descending order, where the corresponding predicate is equal to a given value.

SortValue should be either Asc or Desc, and the SortFeild should support three types of datatypes such as Integer, Datetime, and String.

String

String

Split

String

Returns a specific part of a string split using a separator.

String

String

Sqrt Math The square root of the input value. Double Double

Substring

String

Returns part of a string.

String

String

Sum

Math

Sum of given values.

Double

Double

Switch Special Returns the string based on the input value and corresponding mappings (delimiter is ':') String String

TimeDiff

DateTime

Returns the period between two DateTime values.

DateTime, DateTime

TimeSpan

ToLower

String

Converts to lowercase text.

String

String

ToProper

String

Converts to proper case text.

String

String

ToUpper

String

Converts to uppercase text.

String

String

Trim

String

Removes all leading and trailing white spaces.

String

String

TrimLeft

String

Removes the leading white spaces.

String

String

TrimRight

String

Removes the trailing white spaces.

String

String

Truncate Math The integral part of the value. In other words, rounds up or down towards zero. Double Double
Week DateTime Returns the standard week number of the input DateTime value. DateTime Double
Year DateTime Returns the year part of the input DateTime value. DateTime Double

About Mapping Link Fields

When specifying links to a related business object as part of data import, note the following:

Data import can only be linked when using link fields such as OrgUnitLink or ManagerLink. Only a one-to-one link is supported.

For CSV files, the data should display the name of a business object. For example, for organization unit, use the name of the organization. For employee, use the display name of the employee (for example, Marcia S Hendric) rather than the login ID (MHendric).

When mapping link fields, such as OrgUnitLink or ManagerLink, note the following:

For the source value, on the left, use the value of the Display field under the Special Purpose Fields section and not the value of the Display Name field. You need to determine this field name before mapping the fields.

Linked Field Reference

For the target value, on the right, use the name of the link field, such as OrgUnitLink or ManagerLink.

The following shows mapping a linked field using the field name:

Field Mapping Example - Linked Field

About Mapping Files with Currency Data

To prevent errors while importing files containing currency data, map the currency value and the currency type separately.

For example, if your file contains a currency code value such as NNN.NN GBP (for example, 8999.00 GBP), create a column for the numeric value (NNN.NN) and another column for the currency type (GBP).

If that is not practical, then you can use the Split function on the Field Mapping page:

"Currency", , 0 - Split - "Currency"

"Currency", , 1 - Split - "Currency_Currency"

Field Mapping for Currency

Setting the Data Import or Web Service Connection Schedule

After mapping the fields you must schedule the import and associate the mapping with one or more existing or previously created schedule entries.

Data Import Setup Sequence -- Schedule Setting

This option only appears if you select one of the following connection types: Discovery 9.x, File on Shared Folder, FTP, SCCM, EPM Connector, or Secure FTP (SSH), or if you create a new web service connection.

As noted in Setting Up a Data Import Connection, the schedule options are defined and can be viewed in the Schedule Entry workspace . See About the Schedule Entry and Scheduled Jobs Workspaces for more information.

Data Import Schedule

Schedules determine when the import or data connection is added to the queue for processing. You can create multiple entries in the Schedule Entry table to run multiple imports of the same data each day.

1.Select one or more schedules from the schedule list. (Use the Ctrl key to select more than one schedule.)

The application displays information about each schedule that you select at the bottom of the page.

If you are not the owner of a schedule that you have selected, and the schedule is changed by the owner, your import time might be affected.

The supported schedule types are: Daily, Weekly (once a week), or Monthly (once a month with a date).

2.Click Next. The application displays the Review and Publish page.

Reviewing and Publishing Import or Web Service Connection Data

Data Import Setup Sequence -- Review and Publish

Click the Test Transformation button in order to view all the mappings specified by you. The mapping configurations appear in a pop-up window as an xml file. If desired, you can copy and paste the information from this window to another file.

You have four options to review or publish your import data:

Preview: Views the form with your field mappings. All records from the first batch appear showing the mapping configuration and the associated data. You can check these records for import errors before beginning import.

Publish: The application only shows this option if there is a schedule involved, like with the File on Shared Folder, FTP, and Secure FTP (SSH) connection types. Activates the connection so that it can run according to the schedule.

Publish & Run Now: Runs the import immediately and places it on the import schedule.

Publish & Test Run: Runs the import with only the first batch of records. A batch is 200 records. If errors or problems occur in this job, you can go back to your data and troubleshoot before running the entire job.

The application automatically saves all field mappings even if they are not immediately published. After you publish the data, the job runs based on the schedule/s you selected.

Viewing, Changing or Deactivating a Published Connection

1.Log in to the Service Manager application.

2.Open the Integration workspace.

3.Select a record to open and view the settings.

4.To deactivate a Published connection, uncheck the Active check box then click Save.

You can resume the imports by checking the Active checkbox if needed.

Troubleshooting

Troubleshoot your connections using one of the following methods:

View the Integration Log

View the Integration Queue

View the Integration Log

Use the log to view details of the job from the Integration workspace.

1.Log in to the Service Manager application.

2.Open the Integration Log workspace.

3.Select a log to view the details.

Field Description
Name Name of the mapping.
Start Time/ EndTime Indicates the time the job should run and the time the job should end.
Log Type

Queued: Indicates that the source ID from SCCM has been queued in the inventory management asset data processor.

Verified: Indicates that the source ID from SCCM has been successfully created in the Service Manager database.

Stats: Displays statistics about the number of rows processed.

Total Processed Total number of records processed. If no new mappings were added, no records will be processed.
Source ID The root table key shown on the Object Mapping page of the wizard.
Failed Count Displays the number of records that failed to process.
Target ID The Asset ID derived from the asset identifier mapping function on the Field Mapping page of the wizard.
Message Varies based on the log type. the messages can be viewed wile the job is being processed
View the Integration Queue

While the job is being processed, you can view the record from the Integration Queue workspace. After the job is complete you can only view it from the Integration Log workspace.

Questions and Answers

Q.I made attribute mapping changes to the SCCM integration. Whenever I run the integration, it appears to be pulling information for all computers that have been audited since the last SCCM integration was run.

Is it possible to perform a complete import of all computers regardless of when they were last audited by SCCM?

A. Yes. Follow these steps:

1.Log in to the Service Manager application.

2.Open the Integration workspace.

3.Open the integration to update.

4.In the Last Data Changed Time field, set the last scanned date to a really old date, such as January 1, 1949.

Setting an Arbitrary Date for the Last Audit

5.Run the job as scheduled.

The application captures all information.

Example: Importing Configuration Item Relationships

The following is a specific example of importing data for a configuration item (CI) map tree.

In the past, if you wanted to define a relationship between a configuration item and the application, you used the Map Tree tab to link related configuration items, based on a specific named relationship. This process still works, but can be time-consuming if there are many configuration items to map.

In Service Manager Release 2015.1, we have added a new feature that uses data integration to link multiple configuration items from a CSV or Microsoft Excel file. To use this feature, you must have the DataIDs, SourceIDs, and TargetIDs of the configuration item records to link as well as the RecID of the CINamedRelConstraints record that defines the name of the relationship between the configuration items (such as "managed by" or "runs on").

To use this feature, you must have the CINamedRelLink business object which is new in Service Manager Release 2015.1. If you do not have that business object, contact Ivanti.

To import the relationship records, follow the steps in Setting Up a Data Import Connection.  Follow these steps:

1.Follow steps 1-4 in Setting Up a Data Import Connection.

2.In the Connection Type field, select Manual File Upload.

3.In the Data File Name field, click Upload to navigate to the file that contains the configuration item relationship information. In this example, the file is called CIRelations.csv.

4.Test the data import connection by clicking Test Connection and click Close to close the dialog box.

5.Click Next. The application displays the Object Mapping screen.

6.Enter the following:

In the Mapping field, select Add new....

In the Name field, enter a name, such as CI Name Relation mapping.

In the Source Unique Key field, select all three keys (DataID, SourceID, TargetID).

In the Target Business Object field, enter CINamedRelLink [CINamedRelLink#].

7.Click Next. The application displays the Filter Setting screen.

8.Enter the following values:

Source: CIRelations.csv   Target: CINamedRelLink#
DataID --> DataID
SourceID --> SourceID
TargetID --> TargetID

9.Click Next. The application displays the Field Mapping screen.

10.Enter values. See Mapping Fields.

11.Click Next. The application displays the Review and Publish screen.

12.Click Publish & Run Now.