CMDB Table Structure
Within SimpleOne, it is easy to configure and expand CMDB structure to make it meet all your business needs by managing the CMDB class tables. Simple One provides all necessary features and tools allowing tables full customization.
The CMDB structure is built with the configuration records, such as Configuration Items, CI Types and CI Relationships, which, in turn, are based on the relevant CMDB tables of the System Definition catalogue:
| Table | CMDB Record |
|---|---|
| cmdb | - |
| cmdb_class_type | CI Type |
| sys_cmdb_ci | Configuration Item |
| sys_cmdb_relationship | CI Relationship |
Basicaly, custom CMDB tables are inherited from one of these basic or other custom tables depending on their purposes.
CMDB Expansion guideline
The System Definition catalogue contains all the tables that are applied to build the SimpleOne business solutions. You can use all available navigation and filter tools to find the tables you need.
To expand the SimpleOne CMDB Structure, create new tables inherited from the CMDB Tables of the System Definition by following the steps:
- Create a new class table inherited from one of the the cmdb class tables using the Creating Objects features.
- Configure your class table fields and columns, establish relations with other table if it is needed.
- Create new Menu Item list based on the cmdb class table and add it in the CMDB catalogue.
Create a new CMDB Class Table
To create a new CMDB table inherited from a relevant CMDB table, navigate to the System Definition → All tables menu, then press the New button, and follow the steps of Creating Table instruction.
The administrators can also create a CMDB table from the Parent form. Push the New button on the Table tab of the Related Lists area, and follow the steps above.
Configure CMDB Class Table
Set related lists and columns of your CMDB table to define its purpose and establish relations with other CMDB tables via the Related Lists:
| Related List Name | Description |
|---|---|
| Column | Create columns to define a set of fields of your future CMDB record. Push the New button in the Column tab on the Related Lists area, and, then, follow the steps of Creating Column instructrion. You also can create a column and bind it to a relevant CMDB table in the System Definition → All columns menu. |
| Choice | Create Choices, bind them to an appropriate column and establish their possible values. Push the New button in the Choice tab on the Related Lists area, and, then fill in the following fields:
These choises will be contained in a drop-down list and available for selecting one of them by user when filling the future CMDB record from. |
| Table | A Table related list contains all its child tables and allows creating new ones. |
| Client Script | This tab contains all Client Scripts related to your CMDB table. To create a new Client Script related to your CMDB table, push the New button in the Client Script tab, and then follow the steps from the Client Scripts to configure it. |
| Security ACL | This tab contains all Security ACLs that are related to your CMDB table. To create a new Security ACL related to your CMDB table, push the New button in the Security ACL tab, and follow the ACL Creating steps. |
| Business Rule | This tab contains a list of all Business Rules applied to your CMDB table. To create a new Business Rule, push the New button and fill in the Business Rule fields. |
Push the Save or Save and Exit button to apply the changes.
Add a new CMDB Record
To add a new CMDB Record in the CNDB catalogue, follow the steps below:
- Navigate to CMDB catalogue and then click on the Edit icon
next to the CMDB menu bar to enter the Menu Category. - Add a new Menu Item by pushing the New button in the Related Lists area.
- Specify the CMDB Record Order, Table and Link Type. Add a Filter condition with Condition Builder tool if it is necessary.
- Push Save or Save and Exit button to apply the changes.
You can also create a new CMDB Record by pushing the New button from any other Menu Item form.
Use the CMDB Structure tools to implement a new CMDB Record in it and to establish all required relationcships and dependecies with other CMDB records.
