How to get all tables in the "Non-CMDB Tables" in a CMDB query builder?

[Ksnow]

Hello all, @shloke04 @Ankur Bawiskar @Community Alums @Amit Gujarathi @Lipika Golwalka @Amitoj Wadhera @Nayum Pasha 

I am not able to see all the tables in the "Non-CMDB tables in a CMDB query builders like core_company & sys_user tables.

I read somewhere in an article that "A Non- CMDB is shown only if it references any CI table". But in the cmdb_ci_server table I have created reference fields like company & user which are referenced to core_company & sys_user table still I am not able to get them while searching.

Could you please let me know how can I see those tables?

Appreciate your help!

Thanks,

[Kieran Anson]

Not sure what you mean by "where all the details like company, user and groups are available."

[Ksnow]

Sorry for the confusion @Kieran Anson 

We would like to have the list of the servers with a few columns in the report like (Name, Company, owner, backup owner and details of the owner and company) meaning owner location, email address etc.. by dot walking but unfortunately we don't have option to dot walk in CMDB query builder reports.

So what we want to achieve is one is CMDB class is server table with (name, company, owner, backup owner etc..)  and we want another CMDB class is core_company, then join them(two CMDB classes) to get the details of selected value/record in the company field in Server table with core_company table.

Hope it helps to understand.

Is there a way to show core_company, sys_user tables in the "Non-CMDB tables"? Please advise

Thanks

[Kieran Anson]

Currently, it doesn't sound like you need to use the cmdb query builder, unless you're filtering the servers returned based on related configuration items to that server?

Additionally, you can join the outputted u_cmdb_qb_result_* table using a database view if needed

[Ksnow]

@Kieran Anson 

To explain more about the requirement,  we have integration with Datadog they built their integration with ServiceNow to import the data from cmdb_ci_server table and set it as tags on hosts in Ddog using cmdb query builder.

Now, they're looking to have the report with a few columns along with referenced fields data by dot walking the fields.

But we got stuck since unable to dot walk in the output table "u_cmdb_qb_result".

They need to get the details of owner and company site code etc..

How it can be achieved? Please suggest.

Thanks

[Kieran Anson]

So within query builder, are you using the functionality of finding relationships between CIs (like below) - I'm just trying to understand if the use of query builder could be ruled out