Report with relation between Requests and Asset linked

[Giuseppe Iannacone]

I was trying to have a report with the relation between a Request (leaver request) and the asset linked to that request, but I'm unable to find the relation ship between the table "Requests" and the table "Asset"

can please help out with this?

[James Ainsworth]

Hi @Giuseppe Iannacone

The links are stored in the table h_cmdb_links. 

Hope that helps.  

[Giuseppe Iannacone]

Hi @James Ainsworth

this partially answer to my question... I'm unable to build a left join criteria for table "Request" and "CMDB Links"

[James Ainsworth]

That message suggests to me that the Request Attachments hasn't been joined to anything.  What do you see if you select the Request Attachments?

[Giuseppe Iannacone]

@James Ainsworth the table attachment is joined and is working fine as expected, the message is related to the cmdb links table, and after some attempt I've found a relationship, but I'm unsure that the relationship I've made is the right one!