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!

[Ankur Bawiskar]

@VIvek V 

you can join those 3 tables based on some common field.

then create report on that database view table

what did you start and where are you stuck?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[VIvek V]

Hi @Ankur Bawiskar  

Couldn't fine common field in all three table 

can you please help me to understand more .
Thanks in advance 
Vivek V

[Ankur Bawiskar]

@VIvek V 

if no common field then how will you join

[VIvek V]

@Ankur Bawiskar 
The link is the connectivity among the tables as follows 
Database instance to server its depends on:: used by
server to business services again depends on :: used by