Newbie question here. We currently have a CMDB rule that sets SHARED assets to an assigned custodian username (ownership details - custodianusername). What we want to do is to also assign the asset the custodian's cost center. Currently, the cost center shows who was logged on the longest. When I tried to add the Cost Center Ownership dataclass, I tried to choose a source to match with the "foreign key to cost center" column type but had no luck.



Here is the current code we are using to pull all shared assets:



SELECT vAsset._ResourceGuid, Inv_Pioneer_Asset_Details.[Asset Purpose], Inv_Pioneer_Custodian_Details.Username AS CustodianUsername

FROM Inv_Pioneer_Custodian_Details INNER JOIN

Inv_Pioneer_Asset_Details ON Inv_Pioneer_Custodian_Details._ResourceGuid = Inv_Pioneer_Asset_Details.[Asset Custodian] RIGHT OUTER JOIN

vAsset ON Inv_Pioneer_Asset_Details._ResourceGuid = vAsset._ResourceGuid

WHERE (Inv_Pioneer_Asset_Details.[Asset Purpose] = N'Shared') OR

(Inv_Pioneer_Asset_Details.[Asset Purpose] = N'Seasonal') OR

(Inv_Pioneer_Asset_Details.[Asset Purpose] = N'Instrument Controller')





Any help or insight would be appreciated! Please see attached file for screenshot of config page.



Thanks!

Dave