Report based on three tables cmdb_ci_appl, cmdb_ci_database, cmdb_ci_server

[User377653]

can anyone help me on the below requirement.

Requirement: Report should be created based on 3 CMDB tables. Application, database, and server table

Tables: cmdb_ci_appl, cmdb_ci_database, cmdb_ci_server

Relationship Type from Application to server should include as below.
Depends on::Used by
Depends on (Primary)::Used by(Primary)
Depends on (secondary)::Used by(secondary)

Relationship Type from Application to database should include as below.
Connected by::connects
Depends on::Used by
Depends on (Primary)::Used by(Primary)
Depends on (secondary)::Used by(secondary)

Columns should include application name, owner, customer, type, Database name, type, server name.

Filter applied: Environment is production and Install Status is active and Application name is anything and Customer is anything.

 report format should be like:

[AndersBGS]

Hi @User377653 ,

have you tried utilizing the CMDB query builder to build you report.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[User377653]

Hi @AndersBGS 

I have tried using CMDB query builder but I am not getting the correct data.

Example: Application1 is available in the application table but when I run the CMDB query builder appication1 is not visible in the results.

Application1 has one of the given relationships from the types mentioned in the query builder