Details on Coalesce Changes in Flexera Integration App for ServiceNow 5.1.3

[#1]

This article describes the coalesce changes in version 5.1.3 of the Flexera Integration App for ServiceNow. It provides details on the coalesce rules that affect Flexera IT Visibility and Flexera Data Platform customers who use the Flexera Integration App for ServiceNow. 

• Introduction
• Table: cmdb_ci_computer
• Table: cmdb_ci_network_adapter
• Table: cmdb_ci_disk
• Table: cmdb_ci_hardware
• Table: cmdb_ci_facility_hardware
• Table: cmdb_ci_ip_phone
• Table: cmdb_ci_peripheral
• Table: cmdb_ci_acc
• Table: cmdb_ci_printing_hardware
• Table: cmdb_ci_rack

Introduction

The release of the Flexera Integration App for ServiceNow version 5.1.3 introduces significant coalesce changes. These changes replace existing coalesce field identifiers with natural identifiers. To understand the impact of these coalesce changes on a table-by-table basis, review the tables in the sections below. 

Table: cmdb_ci_computer

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Computer		Flexera Unique CI ID && Flexera Unique ID	Need to set the priority 250 for Flexera Unique CI ID && Flexera Unique ID entries
	Computer	x_fls_flexera_fnms_flexera_unique_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_network_adapter

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Network Adapter		MAC Address && Name	MAC Address && Name
	Network Adapter	x_fls_flexera_fnms_flexera_unique_id && mac_address && name	Flexera Unique ID, Mac Address && Name

Table: cmdb_ci_disk

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Disk		Device ID, Serial number	Device ID, Serial number
	Disk	u_computer_id && u_name	u_computer_id && u_name

Table: cmdb_ci_hardware

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE CMDB Hardware		Flexera Unique CI ID && Flexera Unique ID	Need to set the priority 250 for Flexera Unique CI ID && Flexera Unique ID entries
	CompuCMDB Hardwareter	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_facility_hardware

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Facility Hardware		Flexera Unique CI ID	Remains the same.
	CMDB Facility Hardware	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_ip_phone

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE IP Phone Hardware		Flexera Unique CI ID	Remains the same.
	CMDB IP Phone Hardware	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_peripheral

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Peripheral Hardware		Flexera Unique CI ID	Remains the same.
	CMDB Peripheral Hardware	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_acc

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Accessories Hardware		Flexera Unique CI ID	Remains the same.
	CMDB Accessories Hardware	correlation_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_printing_hardware

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Printing Hardware		Flexera Unique CI ID	Need to set the priority 250 for Flexera Unique CI ID && Flexera Unique ID entries
	CMDB Printing Hardware	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name

Table: cmdb_ci_rack

IRE Transform Map	Non-IRE Transform Map	Former Coalesce Fields (v5.1.2 and earlier)	Updated Coalesce Fields (version 5.1.3 and later)
IRE Rack Hardware		Flexera Unique CI ID	Need to set the priority 250 for Flexera Unique CI ID && Flexera Unique ID entries
	CMDB Rack Hardware	x_fls_flexera_fnms_flexera_unique_ci_id	Sys_id (logic) Serial number Serial number from serial number table Flexera Unique ID Name