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]

Hey,

I think you misunderstood the line you've copied from the documentation, in order for a non-cmdb table to show it needs to reference a cmdb_ci table (e.g the core_company table would need a field on the table that references cmdb_ci) not the inverse of that.

What are you wanting to achieve? We might be able to help with that

[Ksnow]

Thank you very much for your response @Kieran Anson 

If I understand well company field referenced to core_company should be there on cmdb_ci table, correct? If yes, then we have a field company on cmdb_ci table.

One of our clients want to extract the data from 4 tables in ServiceNow via CMDB query builder. They thought they don't have access to the tables which is not true. As ServiceNow admin I am also unable to find them.

Is there any way to show the tables?

Thanks

[Kieran Anson]

If you're wanting to filter based on company, select the CMDB class, and use the filter option.

[Ksnow]

@Kieran Anson 

We would like to filter the data in the server (cmdb_ci_server) table where all the details like company, user and groups are available.

THanks