Skip to main content
Version: 1.12.1

Extend CMDB with Table Inheritance

tip

Role required: cmdb_manager, admin.

To make the CMDB meet your business needs, you can modify it by adding new class tables and configuring the existing ones. The CMDB structure will be built using system tables that will store configuration records and thus organize the CMDB. The CMDB catalog contains all the tables used to build SimpleOne business solutions.

To customize the CMDB structure, add a new class table by following these steps:

  1. Create a new class table inherited from the Configuration Items (sys_cmdb_ci) table.
  2. Configure your class columns and establish relations with other tables if needed.
  3. Create a new CMDB record based on the CMDB class table and add the CMDB category.
note

This method of the CMDB extension is out-of-date and is not recommended to use. Extend CMDB with classes and models instead.

Create a new CMDB class table​

To create a new class table inherited from Configuration items (sys_cmdb_ci) or other relevant CMDB class table, complete the steps below:

  1. Navigate to System Settings → All tables.
  2. Click New and fill in the fields. In the Parent field, select the Configuration Items (sys_cmdb_ci) table or one of its child tables.
  3. Click Save or Save and exit to apply the changes.
note

You can also create a CMDB class from the parent table form. After the form is saved, in the Related Lists area, click New on the Table tab and follow the steps above.

Configure a CMDB Class​

In the Related Lists area in the Table form, you can set up related lists and columns for your CMDB class to define its purpose and establish relations with other CMDB tables. All the tools used to manage the business logic for system records are applicable here as well.

Related ListDescription
ColumnsOn this tab, you can create columns to define a set of fields for the CMDB class table. Click New and follow the steps described in the Create Columns article.
You can also create a column and bind it to a relevant CMDB table in the System Settings → All columns menu.
ACLsThis tab contains all security ACLs that are related to your CMDB class table. To create a new security ACL related to your class, click New and follow the steps described in the Create ACL Rules article.
Client ScriptsThis tab contains all client scripts related to your CMDB class table. To create a new client script related to your class, click New and follow the steps described in the Client Scripts article.
Business RulesThis tab contains a list of all business rules applied to your CMDB class table. To create a new business rule, click New and fill in the Business Rule fields.
Option Value for TableThis tab contains a list of option values used in your CMDB class table. To create a new option value, click New and fill in the Option Value field.
TranslationsThis tab contains translations of the table title. See the Translated Text Fields article to learn more.
VCS RecordThis tab contains the table record versions. See the VCS Records article to learn more.

Add a new record to CMDB catalog​

To add a new class table to the CMDB catalog, follow the steps below:

  1. In the Navigator, type CMDB and click the edit icon next to the CMDB menu category.
  2. In the Menu Category form, scroll down to the Related Lists area, select the Menu Item tab, and click New.
  3. Fill in the fields.
  4. Click Save or Save and exit to apply the changes.
  5. Use the Configuration Management Database (CMDB) to implement a new CMDB catalog in it and to establish all required relationships and dependencies with other CMDB records.

Create a new CI type​

In SimpleOne, IT services are considered configuration items, along with the constituent components required for proper service delivery. A CI type specifies a set of CI attributes and their hierarchical position in the service model structure.

To identify your CI, either as an IT service or as a custom CI, you first need to determine your CIs diversity with the CI Type list.

To create a new CI type, complete the steps below:

  1. Navigate to CMDB → CI Types and click New.
  2. Fill in the Name field.
  3. Click Save or Save and exit to apply the changes.

The created CI type appears at the beginning of the list. Since each CI type defines the hierarchical level of the Service Dependency Map, creating a new one results in adding the next one at a lower level in the model.

In the Related Lists area, you can add CI records to categorize them by type.