Join the cmdb_sam_sw_install x cmdb_ci tables using the Database View

[DiegoCamacho]

Hi, 

I'm trying to join the cmdb_sam_sw_install and cmdb_ci_computer tables, as I need to consult the licenses assigned to the users' equipment. But the way I did it, it's not bringing any information.

[Brad Bowman · Accepted solution]

You need to join on like fields - not a sys_id and a string display name.  It sounds like installed_on is the SAM column you want:

pc_sys_id = sam_installed_on

[DiegoCamacho]

Tks Brad!!

[Brad Bowman]

You are welcome!