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