CMDB report to fnd Servers not mapped to Application using CMDB Query Builder

[dasbiswa]

CMDB report to fnd Servers not mapped to Application using CMDB Query Builder?

I am new to this CMDB Query Builder.We have established relationships between Server and Applications, but there are servers which are not yet mapped with Application.

How can i extract a report using CMDB Query Builder which will fetch the Servers which are still not mapped ?Please advise.

Thanks & Regards

Biswajyoti Das

[Mark N_ · Accepted solution]

Biswajyoti,

First, select 'Server' from the CMDB Artifacts on the left of screen (Hardware -> Computer -> Server) and drag it into the query builder.

Next, select 'Application' from the CMDB Artifacts on left of screen and drag it into the query builder. Hover over Application 1, click the filter icon, and apply a filter 'Class - Is - Application'.

In the query builder, hover over 'Server 1' and click the checkbox on the right. Then hover over 'Application 1', and click the checkbox on the left. This makes a connection from Servers to Applications.

The Connection Properties box will open. Under 'Application 1[Parent] - Server 1[Child]' check the No Relations box, and click confirm.

This query will ask "What servers are not the child in a relationship with an application". Press Run and you'll have your results.

-Mark

[dasbiswa]

I got that Mark nevertheless thanks for sharing.

Appreciate your help.!!!!

[Runjay Patel]

Check out this video, it will clear all your doubts and help you to understand Cmbd Query Builder queries in details.

Link: https://www.youtube.com/watch?v=VUu3W2Xt_mI&t=93s&ab_channel=ServiceNowHelpdesk

It help you to understand below points.

• Overview of CMDB Query Builder
• How to create complex query
• Will generate report which will help to make better business decision.
• CMDB Query Builder feature.
• Use cases like simple, complex, multilevel etc.

Please mark reply as Helpful/Correct, if applicable. Thanks!!