...
Display Name | Table Name |
|---|---|
Categories¹ | |
IT Business Services | |
IT Provider Services | |
Applications | |
Modules | |
Relationships | |
Servers | |
¹ 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.
...
Object | Example URL |
|---|---|
Categories (Test) | https://yaletest.service-now.com/sc_category_list.do?&sysparm_view=CMDB&CSV |
IT Business Services (Test) | https://yaletest.service-now.com/u_it_business_service_list.do?&CSV |
IT Provider Services (Test) | https://yaletest.service-now.com/u_it_provider_service_list.do?&CSV |
Applications (Test) | |
Servers (Test) | https://yaletest.service-now.com/cmdb_ci_server_list.do?&CSV |
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. For convenience, here are the some labels filtered by CI type:
...
Table
...
Labels
...
Business Services
...
...
Provider Services
...
...
Applications
...
...
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 |