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:

...

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

Field Mappings

...

Table

...

Labels

...

CI (all types)

...

https://yale.service-now.com/sys_documentation_list.do?sysparm_query=name%3Dcmdb_ci&sysparm_view=

...

Business Services

...

https://yale.service-now.com/sys_documentation_list.do?sysparm_query=name%3Du_it_business_service&sysparm_view=

...

Provider Services

...

https://yale.service-now.com/sys_documentation_list.do?sysparm_query=name%3Du_it_provider_service&sysparm_view=

...

Applications

...

https://yale.service-now.com/sys_documentation_list.do?sysparm_query=name%3Dcmdb_ci_appl&sysparm_view=

...

Modules

...

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