1:n+1:n in a cmdb qeury builder

[Kody]

Hello,

The following page shows a sample nested 1:n relationship as "Configuration items (CIs) tables [cmdb_ci_*] ..."
https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/csdm-implementation/referen...

[cmdb_ci_service_discovered]->[cmdb_ci_lb]->[cmdb_ci_appl]->[cmdb_ci_server]

I believe the following three tables have two 1:n relationships:

[cmdb_ci_computer]->[cmdb_software_instance]<-[cmdb_ci_spkg]

How can I define the tables and the relationships in a cmdb query builder?

Does the following page has useful description?

https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/configuration-management/co...

Regards,

[Mateus Oliveira]

Hi @Kody ,

The documentation links you shared certainly contain good information in which you should rely on for building your queries in CMDB Query Builder. If you are seeking for more real examples and some hands-on cases, I recommend this video which was very useful for me: CMDB Query Builder Queries & Reporting - Platform Analytics Academy - October 19th, 2022 - YouTube I hope this helps you.

Please, mark my response as helpful 👍 in case it helped you. Also, please mark the question as answered if your issue is solved. This really helps future readers.

[Kody · Accepted solution]

Hello,

I found the answer for my question in the following docs page:
https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/configuration-management/ta...
>Note: A non-CMDB table cannot be the starting node in the query.

Regards,

[Kody]

The following is also useful for me:
Intro to CMDB Query Builder with Reporting - Performance Analytics Academy - Aug 12, 2020