- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2022 04:12 PM
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
Solved! Go to Solution.
- Labels:
-
Data Health Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2022 08:37 PM
Recommended fields can be obtained from the cmdb_recommended_fields table and the recommended column is a comma-separated field names list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2022 04:05 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2024 06:32 AM
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.