Class Table

Description

Class contains the Table entity of the IT (CMDB) model solution.

Location and referencing

Location	Code	Name
Model	it	IT
Class	table	Table
Parent class	ci	Configuration items
Child classes
Script object	OG.ClassDef.GetByCode(OGModel.Id, 'table') OG.ClassDef.GetByCode('it', 'table')

Columns

Overview of class columns (excl. system columns, for inhereted columns see parent classes):

Code	Name	Type	Link information	Description
cl-table	Code table - Table	Revers class link (multiple)	Code table (revers)	Automatically created column.
cl-table-2	Data entity - Table	Revers class link (multiple)	Data entity (revers)	Automatically created column.
column-count	Column count	Integer		Count of columns in the table.
datasource	Data Source	Class link (simple)	Data source	Database (data source), into which the table belongs to.
description	Description	Text		Description of the table.
filegroup	File group	Class link (simple)	File group	File group, into which the table belongs.
is-partitioned	Is partitioned?	True/untrue		Indicates, whether the table is partionened.
rows-count	Rows count	Integer		Count of rows in the table.
schema	Schema	Text		Scheme, into which the table belongs.
table-name	Table name	Text		Name of the table.

Quick filter

In order users can easily filter the records some columns are selected for a Quick filter.

Master/detail relations

Code	Column	Placement	Bookmark name	Type
code_85	Incident - Related CI	Below	Incidents and Problems	Reference to class
code_86	Problem - Related CI	Below	Incidents and Problems	Reference to class
code_87	Changes - Affected CI	Below	Changes	Reference to class
added_by_project	Project - Added configuration items	Below	Projects	Reference to class
modified_by_project	Project - Modified configuration items	Below	Projects	Reference to class
removed_by_project	Project - Removed configuration items	Below	Projects	Reference to class
tasks	Task - Affected CI	Below	Projects	Reference to class
work_schedule	Work schedule - Affected CI	Below	Projects	Reference to class
kb	Article - Configuration items	Below	KB	Reference to class
rfc	Change request - Affected CI	Below	Change requests (RFC)	Reference to class

Potential improvements

You can improve the solution according to your needs. Here are some tips.

Add new columns

Add new columns, if you are going to need them.

Add buttons

Add new buttons to automate edits that you would otherwise make one at a time.