Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Display Name

Table Name

Categories¹

sc_category

IT Business Services

u_it_business_service

IT Provider Services

u_it_provider_service

Applications

cmdb_ci_appl

Modules

u_cmdb_ci_module

Relationships

cmdb_rel_ci

Servers

cmdb_ci_server

¹ technically, these is not a CMDB table as categories are not CIs in ServiceNow. Use of the available "CMDB" view is recommended for this table.

...

CMDB Schema

Overview

The CMDB is represented in an object-oriented fashion. There are some key points to understand:

  • Labels are the table and field names seen in the UI. The underlying schema names may differ.
  • different cmdb_ci_* tables represent different classes of CI. Each class self-identifies via the Class sys_class_name column.
  • CI classes exhibit a hierarchy:
    • cmdb_ci is the base class for CI types. From the systems's perspective, anything in this table or child tables are CIs. So listing all cmdb_ci rows will also show you rows in child tables (e.g. cmdb_ci_appl)
    • Child classes are extensions of the parents, so they inherit the parent columns
    • Child classes may (and probably will) have their own type-specific columns
  • For scope purposes, separate classes may have columns of the same name, but belong to the child and not the parent.
  • relationships have two common types:
    • references (many-to-one) - a column that points to another record.
    • relationships (many-to-many) - a m2m table which glues many records to many others. The CMDB uses cmdb_rel_ci to do this, though custom m2m tables may exist.

...

  • parent - a GUID (sys_id) of the "parent" record of the relationship
  • child - a GUID (sys_id) of the "child" record of the relationship
  • type - the selected relationship type. The semantics of the various types are subject to revision. To start, we are creating a generic "Parent of::Child of" and using that by default.

Label to Schema Mappings

Schema names underlying table and field labels can be seen in the sys_documentation table.

Business Services

Label

Schema Name

Number

u_number

Name

name

Service Category

u_category

State

install_status

Portfolio Owner

u_portfolio_owner

Business Owner

owned_by

Support Group

support_group

Provider Services

Label

Schema Name

Number

u_number

Name

name

Service Category

u_category

State

install_status

Portfolio Owner

u_portfolio_owner

Business Owner

owned_by

Support Group

support_group

Applications

Label

Schema Name

Number

u_number

Name

name

State

install_status

Platform Testing Required

u_platform_testing_required

Short Description

short_description

Assignment Group

support_group

CI Owner

supported_by

Business Owner

owned_by

Used by

u_used_by

Vendor

u_vendor

Application Scope

u_application_scope

Data Classification

u_data_classification

Client Name

u_client_name

Recovery Tier

u_recovery_tier

Modules

Label

Schema Name

Number

u_number

Name

name

State

install_status

Servers

Label

Schema Name

Serial number

serial_number

Name

name

Functional Sponsor

u_functional_sponsor

Assignment Group

support_group

CI Owner

supported_by

State

install_status

OS Family

u_os_family

OS Version

os_version

Short Description

short_description