After an off-box upgrade, importing cost center data exported from the old database does not show Cost Center data in the
Assets by Type, Status, Department, Cost Center and Location report.
The connector import was missing configurations to create an association to a Cost Center.
cc.[Name] as 'Owner',
FROM inv_cost_center_ownership AS id
JOIN Inv_AeX_AC_Identification AS ac on ac.[GUID] = id.[_ResourceGuid]
join vRM_Cost_Center_Item cc on cc.Guid = id.Owner
where ac.guid <> ''
Release : 8.x
Added the association to a Cost Center.