Creating a complex report

[iamkurt]

I want to create a report with the columns below. Columns are separated by ||

Application Name || Application Criticality || Application Core || Capabilities || Owner Name || Unit Name || Software Name || Product Name || Cloud/On-Prem

First 2 columns – Application name and App Criticality – I find them on cmdb_ci_business_app table. Last 3 columns – Software Name, Product Name and Cloud/ On-Prem – I need to get from SAM tables.

How can I create such a report?On cmdb_ci_business_app table, open any record. I related items → go to “Mapped Application Services” → Clicked in any entry you see under “Mapped Application Services” → In my case “cmdb_ci_service_discovered” table opened. Some other table might open based on whats your case → From hamburger icon, change View to “Technology Models Retrieval” → Under related lsist, you see “Application Service Software Models” → Click New → You can see a reference field for “Software Model”.

So apparently, all these can be tied in a report.

Can someone advise me how can I achieve this?

[WBit]

Use the CMDB Query builder or create a database view of the tables you need to connect.

[Mark Manders]

As was mentioned on the Telegram channel: use the CMDB Query Builder or create a Database View with the tables you need to get the fields.