What is the table that holds the list of all CI Classes?

Louis Evans
Giga Contributor

I am building an application and I want to be able to read the settings specific to a class (not individual CI data).  For example;

  • if a specific Effective Duration for a CI Class has been created I want to read that.
  • if recommended fields have been assigned to a specific CI Class I want to be able to read what they are

Essentially I want to read CI Class level data, not the data of the CIs themselves.  Is there a table or tables I can access for this info? 

Thanks in Advance
Louis

1 ACCEPTED SOLUTION

Sandeep90
ServiceNow Employee
ServiceNow Employee

Recommended fields can be obtained from the cmdb_recommended_fields table and the recommended column is a comma-separated field names list.

View solution in original post

6 REPLIES 6

Thank you Sandeep.  Your answer helped me work out how to get all the CMDB management types of tables.  Listing all the tables starting with cmdb returns over 1000 tables, because all the Class tables are displayed, which is not much help. But, from your answer I deduced the following criteria; starts with cmdb  and does not contain cmdb_ci. 
This reduces the number of tables dramatically by not bring back class tables, leaving mostly the CMDB  management tables which is precisely what I wanted.

Artem Tyndyk
Tera Expert

If you use principal classes, all your CI classes that had ever been marked as principal are stored in the "CMDB Class Information" [cmdb_class_info] table. Even after you de-select a class as principal, it is still listed in that table. Perhaps, this solution could be also useful for your use case.