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.
Release : 8.x
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 <> ''
Added the association to a Cost Center.