Help: How to join Database Instance, Server CI & Business Service details in one view?

[VIvek V]

Hi Everyone,

I need to build a single view/report in ServiceNow that combines fields from the following tables:

• Database Instance (cmdb_ci_database)

• Server CI / Host (cmdb_ci_server)

• Business Service (cmdb_ci_service or related service table)

My required fields are:

Source Table Required Fields

Database Instance	All instance data
Server CI	Server Name, Hostname, OS, OS Version
Business Service	Support Group, Point of Contact

I'm looking for the correct way to achieve this — whether using Database View, Report with joins, CMDB relationships, or any recommended method.

Has anyone created similar data joins?
If yes, can you please guide me on:

1. Best approach (DB View vs Reporting joins?)

2. Sample relationship mapping for these tables

3. Any performance considerations?
   
   I tried using Query Builder to achieve this requirement, but it is not giving the correct results.

Thanks in advance!

[VIvek V]

@Ankur Bawiskar 

any help ?

[Breno Abreu]

You can create a CMDB Query for that.

It brings same features on the view with the benefit that in the background it creates a table with the results ("kind of materialized view") that you can define the refresh rate.
Then you report on that.

[VIvek V]

Thanks @Ankur Bawiskar  Quick response 

[Ankur Bawiskar]

@VIvek V 

not very sure on that