High Level ServiceNow Data
Model Relationships
2
Task
Data Model
Task
Cards
3
9
Catalog Task
Approval Task
Service Catalog
Data Model
Content
Item
Knowledge
Data Model
Available
for
Affected CI
Impacted Service
Business
Service
Affected
Products
Expense
Line
7
Supported by
Approval Group
Managed by
CI Cards
4
CMDB
Data Model
Expense
Allocation
IT Cost Management
Data Model
Expense
Line
CI linked to Asset
5
Asset & Contract
Data Model
Model Category
6
Model
Data Model
Caller
Requested by
Assigned to
Location
Requested by
Requested for
1
Organizational
Data Model
Measures Service
Levels provided
Contract Users
Contract Locations
8
SLA
Data Model
Cost Center
Department
Assigned to
Owner
Location
Chargeback to
Assets Covered
1
Organizational Data Model
Location
cmn_location
Parent
Company
core_company
Parent
Cost Center
cmn_cost_center
Parent
Building
cmn_building
Stockroom
alm_stockroom
Department
cmn_depart ment
Parent
User
sys_user
Manager
Has roles
sys_user_has_role
Roles
sys_user_role
Is member of
sys_user_grmember
Has roles
sys_group_has_role
Group
sys_user_group
Types (examples)
Support (ActionCentre)
Access (DL, Security)
Catalog: (Approval)
Change (CAB)
Location
cmn_location
Type: Country
Parent
Location
cmn_location
Type: Prov/State
1b
Organizational Data Model (Hierarchical example)
Company
core_company
Company
core_company
Parent
Cost Center
cmn_cost_center
Type: PNL
Parent
Cost Center
cmn_cost_center
Type: Customer
Parent
Department
cmn_depart ment
Type: Divi sion
Parent
Department
cmn_depart ment
Type: Business Uni t
Parent
Location
cmn_location
Type: City
Parent
Location
cmn_location
Type: Building
Parent
Location
cmn_location
Type: Room
Stockroom
alm_stockroom
Parent
Parent
Cost Center
cmn_cost_center
Type: Cost Center
Department
cmn_depart ment
Type: Section
Parent
Department
cmn_depart ment
Type: Department
User
sys_user
Is member of
sys_user_grmember
Has roles
sys_user_has_role
Roles
sys_user_role
Group
sys_user_group
eg. Network
Parent
Group
sys_user_group
eg. Network-East
Has roles
sys_group_has_role
Types (examples)
Support (ActionCentre)
Access (DL, Security)
Catalog: (Approval)
Change (CAB)
1b
Skills Management Data Model
User
sys_user
Has Skills
(sys_user_has_skill)
Task
task
Is member of
(sys_user_grmember)
Group
sys_user_group
Tasks can be assigned
based on required skills
Skills
cmn_skill
Has Skills
sys_group_has_skill
Contained Skil ls
cmn_skill_contains
Skills Required for
Model Maintenance
cmn_m2m_skill_model
Product
Model
cmdb_model
2
Task Data Model Extensions
Task
task
Fields defined at task level
(inherited by all extended tables)
- Active
- Activity Due
- Additional Comments
- Approval
- Approval History
- Approval set
- Assigned to
- Assignment Group
- Business Duration
- Close Notes
- Closed
- Closed by
- Comments & Work notes
- Company
- Configuration Item
- Contact Type
- Contract
- Correlation ID
- Correlation display
- Created
- Created by
- Delivery plan
- Delivery task
- Description
- Domain
- Due date
- Duration
- Escalation
- Expected start
- Follow up
- Group list
- Impact
- Knowledge
- Location
- Made SLA
- Number
- Opened
- Opened by
- Order
- Parent
- Priority
- Reassignment Count
- SLA due
- Service offering
- Short Description
- Skills
- State
- Sys ID
- Task type
- Time worked
- Updated
- Updated by
- Updates
- Upon approval
- Upon reject
- Urgency
- User input
- Watch list
- Work end
- Work notes
- Work notes list
- Work start
- Questions
- Label
Incident
incident
Problem
problem
Change Request
change_request
Change Phase
change_phase
Request
sc_request
Requested Item
sc_req_item
KB submission
kb_submission
Loaner Request
loaner_request
Ticket
ticket
Chat Queue Entry
chat_queue_entry
Problem Task
problem_task
Group Approval
sysapproval_group
Change Task
change_task
Catalog Task
sc_task
Issue
issue
Planned Task
planned_task
Private Task
vtb_task
See next page
Change Request
IMAC
change_request_imac
Work Order
wm_order
Work Task
wm_task
Audit Observations
grc_observat ion
Requirements
grc_audit_requirement
Activity
grc_act ivity
Demand
dmn_demand
HR Case
hr_case
HR Change
hr_change
HR Task
hr_task
Service Order
sm_order
Facilities Request
facilities_request
Service Task
sm_task
Facilities Request
Task
facilities_request_task
Task
task
Planned Task
planned_task
- Actual Cost
- Actual Duration
- Actual Effort
- Budget Cost
- Critical Path
- Estimated Cost
- HTML Description
- Level
- Percent Complete
- Planned Duration
- Planned Effort
- Planned End Date
- Planned start date
- Remaining Duration
- Remaining Effort
- Rollup
- Subtree root
- Time Constraint
- Top Task
- WBS
- WBS Order
2
Planned Task Data Model Extensions
Phase
rm_release_phase
SDLC Release
rm_release_sdlc
Enhancement
rm_enhancement
Defect
rm_defect
Testing task
rm_test
Documentation
task
rm_doc
Release Task
rm_task
Test Case
tm_test_case_instance
SCRUM Release
rm_release_scrum
SCRUM Release
rm_sprint
Epic
rm_epic
Story
rm_story
SCRUM Task
rm_task_scrum
Release
rm_release
Feature
rm_feature
Product
rm_product
Test Plan
tm_test_plan
Assessment
cl_assessment
Project
pm_project
Requirement
dmn_requirement
Audit
grc_audit
Project Task
pm_project_task
Decision
dmn_decision
Control Test
grc_control_test
Remediation
grc_remediation
2
How different Task Types Reference CMDB
Task
Incident
Categorization
Impact Services
Affected CI
- Opened by
- Assigned to
- Assignment Group
- Closed by
- Location
- Company
- Configuration Item
Problem Root Cause Analysis
Affected CI
Problem
Change
Change Impact Assessment
Impact Services
Affected CI
Change
Task
Approval
Request
Request
KB
submi ssi on
Planned
Task
Requested
Item
Catalog
Task
Knowledge
Article
kb_knowledge
Project
pm_project
Product
rm_product
Release
rm_release
Business
Service
cmdb_ci_service
Configuration
Item
cmdb_ci
Business
Service
cmdb_ci_service
Configuration
Item
cmdb_ci
Part of
Business
Service
cmdb_ci_service
Create
new
Configuration
Item
cmdb_ci
Related to
Configuration
Item
cm db_ci
Affected CI
Business
Service
cmdb_ci_service
Affected CI
Application
cmdb_ci_apl
2a
Incident Management Data Model
User (Caller)
sys_user
Location
cmn_location
Group
sys_group
Business
Service
cmdb_ci_service
Configurati on
Item
cmdb_ci
Change
change
Caused by Change
Resolved by
Incident
incident
Categorization
Affected CI
task_ci
Problem
problem
Metric
Definition
metric_definition
Metric Instance
metric_instance
Task SLA
task_sla
Configurati on
Item
cmdb_ci