Ivanti Neurons Connector

This topic includes the configuration details for Ivanti Neurons Connector.

To access the Ivanti Neurons Connector settings page:

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

Connection Setting

Prerequisite:

For this feature to work, you must link the tenant with Ivanti Neurons tenant. To do this, contact Ivanti Operations team.

  1. In the Connection Name field, enter a unique name for the connection.
  2. From the Connection Type drop-down list, select Ivanti Cloud Connector.
  1. The following two fields appear:
    1. Cloud Connector API Path: The default path appears as api/discovery/v1/. However, this can be modified, if required.
    2. Cloud Connector Object: Enter the name of the business object for which you want to fetch data.
  2. Click Next. The Object Mapping page opens.

Object Mapping

  1. Enter information into the fields.
Field Description
Mapping Select Add new... from the drop-down list.

The application creates a clone of the mapping, which you can then modify.

This button is only enabled if you select an existing mapping.

Name

Use the default name or modify the name to and click Save as new.

Source Mapping Tables A list of tables that is populated based on the Cloud Connector Object, as defined in step 3b of the Connection Setting phase.
Root Table Select the primary table containing the master data that uniquely defines the computer systems in your organization.
Unique Key Select the field that is primary in identifying your records, which can be used to retrieve additional information. This field 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.
Target Business Object

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 Neurons for ITSM, the primary business object you need to map to is the Employee business object.

Highlight the business object in the list. This field is the primary business object in Neurons for ITSM into which the data is imported.

The list shows all the business objects in Neurons for ITSM.

Exclude Validation Objects

Select this check box if you want to exclude the validation objects that are part of the target business object.
  1. Click Next. The Filter Settings page opens.

Filter Settings

The Filter Manager enables filtering inflow of device types based on the filter criteria. For instance, an Administrator can select to import Asset Type of only Laptop by creating the filter value Laptop.

Filter Manager

•The filter settings made during import remains saved for further import.

•Based on the filter settings, only those messages which are relevant to mapping will be processed by IvantiNeurons for ITSM tenant and rest of the messages will be discarded.

•To filter out null parameters, use the NotEqual operator instead of NoContain . For example, when filtering device which does not have serial number to sync from Neurons.

•The filter settings works only for single value filter in each row. If the field selected in the left panel of the mapping results multiple values, then those filters will not work. It advised to use the filter settings accordingly.

For example, if you choose Device.BIOS.BIOSSettings in root table and all the properties related to Device.BIOS.BIOSSettings will be displayed on Filter settings page.

When you set the filter settings as shown in the images below, then the filter will not work.

Field Mapping

This page is used 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.

  1. If appropriate, select a transformation function from the middle column.
  2. Select the field names to map the source file and the target business object in Neurons for ITSM.

For example: Invoice.InvoiceNumber would map to Neurons for ITSM ivnt_InvoiceNumber asset identifier.

  1. Select a transformation function from the second column, if required by your organization.

Function Name

Category

Description

Input

Output

-->

None

Returns the source value (does nothing).

    
Abs Math The absolute value of input value. Double Double
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

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
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

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
  1. If the target field is a link field, determine the name of the field to use. See Mapping Fields.
  2. (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.
  3. Click Next. The Review and Publish page opens.

Review and Publish

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

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 Neurons for ITSM.

2.Open the Integration workspace.

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

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

You can resume the imports by selecting the Active check box, if needed.