Hello everyone,
I've create a couple of custom assets (e.g. datacenter data class with two rows).
After creating a association and assign it to a Computer Asset, all i see is duplicated rows for this computers associated: a correct one field with a NULL one).
Anybody knows why this happens? I see duplicated fields. My query is below so you can check is ok.
select distinct
vComputer.Name
,Inv_Datacenter.[datacenter-name]
from
vComputer
left join ResourceAssociation
on vComputer.Guid = ResourceAssociation.ParentResourceGuid
left join Inv_Datacenter
on ResourceAssociation.ChildResourceGuid = Inv_Datacenter._ResourceGuid
--left join dbo.vHWComputerSystem
-- on vComputer.Guid = dbo.vHWComputerSystem._ResourceGuid
--where [datacenter-name] is not null
order by
vComputer.Name
Thanks for the response.