Optimizing Infrastructure CI Listing for Application Services Using CMDB Query Builder

[senon]

Hello, experts.

I would like to display a list of infrastructure CIs associated with application services. I understand that there are two methods to link multiple tables for reporting: 'CMDB Query Builder' and 'Database View.'

In the 'Database View,' tables need to be joined at each relation level, which I find lacking in versatility. Therefore, I am using the 'CMDB Query Builder.'

■ Questions
① In the 'CMDB Query Builder,' the relation level can only be selected up to level 2, so I cannot display CIs at deeper levels. Is the maximum relation level indeed limited to 2?

② Additionally, if there is a better way to display a list of infrastructure CIs associated with application services, could you please let me know?

■ Current Configuration
Here is the dependency diagram of the application services and infrastructure CIs.

Here are the settings for the CMDB Query Builder.

These are the results displayed based on this configuration.

Best regards.

senon

[senon · Accepted solution]

I've managed to solve this problem myself, so I'd like to share it with you.

The way to display all CIs associated with an application service is to use the Service Configuration Item Association table [svc_ci_assoc].

The documentation for this table can be found here.→Service tables

This allowed the database view I created to perform just as I wanted it to.

My preference is for a list view.

Defining

Try it!

I also referred to the content of this community. → Database Views for CMDB Reports - ServiceNow Community