View Source

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 category in All tables menu contains all the CMDB Tables

go to the System Definition → All tables menu and apply the following filter conditions:

cmdb...

o create and add new inherited CMDB classes, to establish relationships between them and to determine class policies, as well as the attributes of control and assess.

Make your structure comprehensible and with CMDB tools. CMDB Class Wizard features help administrators to build a CMDB solution that satisfies your business needs.

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 System Definition → All tables, then press the New button, and follow the steps of Creating Table instruction.

The can also create a CMDB table right from the its Parent form. Push the New button on the Table tab of the Related Lists area, and follow the steps of Creating Table instruction.

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: Table - is filled in with your CMDB table name; Column - select a column which should contain possible values in a drop-down list; Title - Enter a Choice title displayed in a drop-down list of a CMDB record selection field; Value - define a Choice value with number; Order - determine a Choice place in a drop-down list order; Hint - type a text here if necessary. 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

Navigate to CMDB catalogue and then click on the Edit iconnext 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.