CMDB Query Builder - can't find core tables such as Company, User etc?

[Talal Najam]

Hi, I'm trying to report on Service Offerings. Since you can't dot walk in Query Builder, I'm searching for core tables to get their attributes. For example, a Service Offering's related company (from Service Subscription by Company table) and that company's Service Relationship Manager and then join with some custom table. But I can't seem to find any core / foundation table (such as Company, User, Group etc.) even in the Non-CMDB tab. 

I can partially achieve this by using dot-walk with standard report module but I need to use another custom table that's referenced therefore need to use the Query builder. Any ideas? Thanks

[Kristen Ankeny · Accepted solution]

You're probably going to want to use a database view instead - this will allow you to build the joins and display the data from multiple tables. https://docs.servicenow.com/bundle/quebec-platform-administration/page/use/reporting/concept/c_DatabaseViews.html

[Ksnow]

Hi @Talal Najam @Kristen Ankeny 

I am also looking for the same for other team members they have access to CMDB query builder and tables in ServiceNow. But we are unable to find the core_company table in the "Non-CMDB tables" even though we have used company field on the server table which is referenced to core_company table.

Please let me know how to find this table in CMDB query builder.

Thanks alot

[Kristen Ankeny]

The CMDB Query builder includes tables that have a reference back to a CI class table, rather than tables that CI classes reference. Since the tie to company is a reference field on the CI record, you won't find core_company in the list. However, you can build your query with the CMDB data you need and then use that query in a report. From the report configuration you can expand/dot walk the reference to company to get details from those records.