...
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.
...
Otherwise, you'll see the list view in the ServiceNow UI.
Views
Different groups have different data needs. When using some data types, exports can be done against a specified view, which can provide a specific set of fields. Example views are "eGRC" (for cmdb_ci_application) and "CMDB" (for sc_category).
URL Examples
Combine the querie with the desired instance name, along with the the https scheme, to get a URL.
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:
- 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 Classsys_class_namecolumn. - CI classes exhibit a hierarchy:
cmdb_ciis the base class for CI types. From the systems's perspective, anything in this table or child tables are CIs. So listing allcmdb_cirows 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_cito do this, though custom m2m tables may exist.
Understanding Relationships
cmdb_ci_rel has three fields:
- 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 |