Create the Report for CMDB Application has Contracts or not

[ysudileti]

Hi All,

I have a requirement to create the Report for CMDB application has contract details or not if application has contract details contract has attachment or not. 

Table1: cmdb_ci_appl

Table2: u_contracts

Table3: sys_attachments.


I am trying to create the report by using Database view but not getting expected output. Could you help any ideas and guidance to get the report.

Thanks,
Yamini

[Pratiksha]

Did not understand the question. Why you are using custom contract table ? 

[Damhoej]

I am not sure if I understand the task correctly, but it looks like you could do it with Query Builder