Transcript ServiceNow Data Model

High Level ServiceNow Data
Model Relationships
2
Task
Data Model
Catalog Task
Approval Task
Service Catalog
Data Model
Content
Item
Knowledge
Data Model
Available
for
Caller
Requested by
Assigned to
Location
Task
Cards
Business
Service
1
Organizational
Data Model
Measures Service Contract Users
Levels provided Contract Locations
Supported by
Approval Group
Managed by
Expense
Line
Expense
Allocation
IT Cost Management
Data Model
4
CMDB
Data Model
CI Cards
7
Cost Center
Department
Affected
Products
Affected CI
Impacted Service
Requested by
Requested for
8
9
3
Expense
Line
CI linked to Asset
Assigned to
Owner
Location
Chargeback to
SLA
Data Model
5
Asset & Contract
Data Model
Assets Covered
6
Model Category
Model
Data Model
1
Organizational Data Model
Cost Center
Company
cmn_cost_center
core_company
Location
cmn_location
Department
cmn_department
User
sys_user
Reports to
Skill
Has Skills
Has roles
Roles
cmn_skill
sys_user_has_skill
sys_user_has_role
sys_user_role
Contained Skills
cmn_skill_contains
Is member of
sys_user_grmember
Has Skills
sys_group_has_skill
Has roles
(sys_group_has_role)
Group
sys_user_group
Types (examples)
Support (ActionCentre)
Access (DL, Security)
Catalog: (Approval)
Change (CAB)
2
Task Data Model Extensions
Business
Servi ce
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
Problem
Task
Business
Servi ce
Change
Change Impact Assessment
Impact Services
Affected CI
Approval
Request
Configuration
Item
Change
Task
Request
Part of
Business
Service
Requested
Item
Catalog
Task
Create
new
Configuration
Item
KB
submission
Knowledge
Article
Related to
Configuration
Item
Planned
Task
Project
Categorization
Affected CI
Project
Task
Release
Categorization
Affected CI
Defects
Enhance
ments
Application
3
Service Catalog Data Model
Category
Product Model
Product Catalog Item
(sc_category)
cmdb_model
pc_product_cat_item
Record
Producer
Task
sc_cat_item_producer
Incident,
Change,
Enhancement
, Defect,
Project etc
Vendor Catalog
pc_vendor_cat_tiem
Business Service
Catalog Entry
Catalog Item
(sc_cat_item)
sc_cat_item_service
Request
Ordered Item
Link
sc_request
sc_ordered_item_link
Creates
Requested
Item
sc_request_item
Grouped
together by
Workflow
Service Offering
Workflow
Approval
Activity
Creates
service_offering
Approval
User
sysapproval_
approver
Approval
Group
Workflow
Task
Activity
sysapproval_
group
Creates tasks to
fulfill the request
When closed it
creates a CI *
Task
1. Order & Receive
2. Configure
3. Install
Configuration
Item
cmdb_ci
Catalog Item
(sc_cat_item)
3a
Service Catalog Data Model Extensions
Configuration Item
Product Model
cmdb_ci
cmdb_model
Hardware Catalog
Product Catalog Item
pc_hardware_cat_item
(pc_product_cat_item)
Software Catalog
(pc_product_cat_item )
Hardware Model
Business Service
cmdb_hardware_product_model
cmdb_ci_service
Record Producer
sc_cat_item_producer
Service Offering
service_offering
Task
Content Item
task
sc_cat_item_content
Request
sc_request
Wizard Launcher
sc_cat_item_wizard
Requested Item
sc_request_item
Order Guide
sc_cat_item_guide
Approval Group
sysapproval_group
Business Service
Catalog Entry
Approval (user)
sc_cat_item_service
sysapproval_approver
Catalog Task
sc_task
CMDB Data Model
4
User
Location
Group
Business
Process
Access
provided by
Is enabled
by
Is member of
Provides
access to
Enables
Business
Service
Computer
Room AC
Depends on
Email
Application
Used by
Exchange
Network
Switch
Runs on
Used by
Bus iness
Service
Catalog
Entry
Runs
Exchanges
data with
Catalog
Item
Business
Service
Server
Sends
data to
BlackBerry
Used by
Receives
data from
BES
Depends on
Application
Computer
Room
Cooled by
Exchanges
data with
Depends on
Data
Center
Contains
Cools Room
Located
in
Houses
Located
in
Storage
Device
Zone
Zone
contains
Depends on
Runs on
In Rack
Rack Contains
SLA
Service
Offering
- International
- Local
Runs
Server
M
Service
Availability
Service
Subscription
by Location
Powers
Database
Service
Subscription
by User
Depends on
Feeds
MSFT
SQL
Instance
Outages
DR
Provided by
Location
Circuit
Fed by
Used by
Provides
DR for
Service
Commitment
Powered by
Hosts
Hosted on
Service
Offering
Service
Commitments
Rack
Located
in Zone
User
Server
DR
3
4
UPS
4a CMDB Hardware Data Model Extensions
Configuration Item
cmdb_ci
Disk
Network Adapter
Memory Module
cmdb_ci_disk
cmdb_ci_network_adapter
cmdb_ci_memory_module
Storage Disk
cmdb_ci_storage_disk
Network Gear
cmdb_ci_netgear
IP Switch
cmdb_ci_ip_switch
Computer
cmdb_ci_computer
IP Router
cmdb_ci_ip_router
Netware Server
cmdb_ci_netware_server
IBM Mainframe LPAR
cmdb_ci_mainframe_lpar
Computer
Peripheral
cmdb_ci_peripheral
Hardware
cmdb_ci_hardware
Printer
cmdb_ci_printer
Accessory
cmdb_ci_acc
Communication
Device
cmdb_ci_comm
Storage Device
cmdb_ci_msd
UPS
cmdb_ci_ups
IP Phone
cmdb_ci_ip_phone
PDU
cmdb_ci_pdu
Server
cmdb_ci_server
Storage Server
cmdb_ci_storage_server
IBM Mainframe
(cmdb_ci_mainframe)
ESX Server
cmdb_ci_esx_server
OS/X Server
cmdb_ci_osx_server
Vmware vCenter Server
Object
cmdb_ci_vcenter_server_ob j
AIX Server
cmdb_ci_aix_server
Windows Server
cmdb_ci_win_server
UNIX Server
cmdb_ci_unix_server
HP Server
cmdb_ci_hpux_server
Linux Server
cmdb_ci_linux_server
CIM Server
cmdb_ci_cim_server
Solaris Server
cmdb_ci_solaris_server
Load Balancer
cmdb_ci_lb
F5 BIG IP
cmdb_ci_lb_bigip
4b
Configuration Item
cmdb_ci
CMDB Application & Software Data Model Extensions
Application
(cmdb_ci_appl)
Web Application
Web Service
Web Site
(cmdb_ci_web_application)
(cmdb_ci_web_service)
(cmdb_ci_web_site)
Patch
Software
cmdb_ci_patches
cmdb_ci_spkg
Oracle Database
Listener
cmdb_ci_db_ora_listener
Application Server
Infrastructure Service
(cmdb_ci_app_server)
(cmdb_ci_infr_service)
Database Instance
(cmdb_ci_db_instance)
Vmware vCenter
Instance
cmdb_ci_vcenter
Tomcat
JavaServer
Directory Server
Email Server
MSFT SQL Instance
cmdb_ci_app_server_tomcat
cmdb_ci_app_server_java
cmdb_ci_directory_server
cmdb_ci_email_server
(cmdb_ci_db_mssql_instance)
JBoss
Domino
LDAP Server
FTP Server
Oracle SQL Instance
cmdb_ci_app_server_domino
cmdb_ci_app_server_domino
cmdb_ci_ldap_server
cmdb_ci_ftp_server
(cmdb_ci_db_ora_instance)
Desktop Software
cmdb_ci_desktop_software
Infrastructure Software
cmdb_ci_inf_software
IBM Websphere
BEA Weblogic
Web Server
IP Server
Notes Instance
Application Software
cmdb_ci_app_server_websphere
cmdb_ci_app_server_weblogic
cmdb_ci_web_server
cmdb_ci_ip_server
(cmdb_ci_db_notes_instance)
cmdb_ci_application_sof tware
4c
CMDB Virtualization Data Model Extensions
Configuration Item
cmdb_ci
Virtual Machine
cmdb_ci_vm
Virtual Machine Object
cmdb_ci_vm_object
Zones
VMware
cmdb_ci_vm_zones
cmdb_ci_vm_vmware
Virtual Machine
Instance
Virtual Machine
Template
cmdb_ci_vm_instance
cmdb_ci_vm_template
VMware vCenter
Object
cmdb_ci_vcenter_object
KVM Object
Hyper-V Object
cmdb_ci_kvm_object
cmdb_ci_hyper_v_object
Parallels
cmdb_ci_vm_parallels
EC2 Virtual Machine
Instance
VMware Virtual
Machine Template
VMware vCenter
Cluster
VMware vCenter
Network
cmdb_ci_ec2_instance
cmdb_ci_vmware_template
cmdb_ci_vcenter_cluster
cmdb_ci_vcenter_network
VMware Virtual
Machine Instance
Hyper-V Virtual
Machine Instance
VMware vCenter
Datastore
VMware vCenter
Datacenter
cmdb_ci_vmware_instance
cmdb_ci_hyper_v_instance
cmdb_ci_vcenter_datastore
cmdb_ci_vcenter_datacenter
KVM Virtual Machine
Instance
Solaris Virtual
Machine Instance
cmdb_ci_kvm_vm_instance
cmdb_ci_solaris_instance
ESX Resource Pool
cmdb_ci_esx_resource_pool
VMware vCenter
Folder
cmdb_ci_vcenter_folder
Storage Pool
Hyper-V Cluster
cmdb_ci_kvm_storage_pool
cmdb_ci_hyper_v_cluster
Network
Hyper-V Network
cmdb_ci_kvm_network
cmdb_ci_hyper_v_network
Storage Volume
cmdb_ci_kvm_storage_volume
Hyper-V Resource
Pool
cmdb_ci_hyper_v_resource
Hyper-V Resource
Pool Component
cmdb_ci_hyper_v_rpool_co
mp
4d
CMDB Service Data Model Extensions
Configuration Item
(cmdb_ci)
Business Process
cmdb_ci_process
Group
cmdb_ci_group
Business Service
Cmdb_ci_service
Service Offering
service_offering
Group Relationship
cmdb_rel_group
4e
CMDB Network Data Model Extensions
Configuration Item
(cmdb_ci)
Network
Infrastructure Item
dscy_net_base
IP Network
cmdb_ci_ip_network
Switch Forwarding
Rule
dscy_swtch_fwd_rule
Next Hop Routing
Rule
dscy_route_next_hop
Wire
dscy_net_wire
Exit Interface
Routing Rule
dscy_route_interface
Network Traffic
cmdb_ci_net_traffic
Exit Interface Routing
Rule
dscy_route_interface
Router Interface
dscy_router_interface
IP Address
cmdb_ci_ip_address
Switch Partition
dscy_swtch_partition
IP Address to DNS
Name
cmdb_ip_address_dns
_name
Switch Port
dscy_switchport
DNS Name
cmdb_ci_dns_name
Wire
dscy_net_wire
Configuration Item
(cmdb_ci)
Storage File Share
Storage Volume
cmdb_ci_storage_fileshare
cmdb_ci_storage_volume
CMDB High Availabilty Data Model Extensions
4f
Environment
Cluster Virtual IP
Cluster Resource
cmdb_ci_cluster_vip
cmdb_ci_cluster_resource
cmdb_ci_environment
Storage Port
Storage HBA
Cluster
Cluster Node
cmdb_ci_storage_port
cmdb_ci_storage_hba
cmdb_ci_cluster
cmdb_ci_cluster_node
Load Balancer
Service
Load Balancer
Pool
Load Balancer
VLAN
cmdb_ci_lb_service
cmdb_ci_lb_pool
cmdb_ci_lb_vlan
Load Balancer Pool
Member
Load Balancer
Interface
cmdb_ci_lb_pool_member
cmdb_ci_lb_interface
Load Balancer
Service VLAN
cmdb_lb_vlan
Load Balancer
Service VLAN
cmdb_lb_vlan_interface
Windows Cluster
Resource
cmdb_ci_win_cluster_resource
Windows Cluster
cmdb_ci_win_cluster
Windows Cluster
Node
cmdb_ci_win_cluster_node
Configuration Item
4f
cmdb_ci
Database
File System
cmdb_ci_database
cmdb_ci_file_system
Database Catalog
CMDB Other Data Model Extensions
Print Queue
IP Service Instance
Tomcat Connector
Websphere Cell
cmdb_ci_print_queue
cmdb_ci_ip_service
cmdb_ci_tomcat_connector
cmdb_ci_ip_websphere_cell
Printer Instance
Printer Instance
cmdb_printer_instance
cmdb_print_queue_instance
cmdb_ci_db_catalog
Printer Supplies
discovery_printer_supplies
MSFT SQL Catalog
Oracle Catalog
cmdb_ci_db_mssql_catalog
cmdb_ci_db_ora_catalog
NFS File System
UNIX Daemon
cmdb_ci_file_system_nfs
cmdb_ci_unix_daemon
Sybase Catalog
MySQL Catalog
SMB File System
Windows Service
cmdb_ci_db_syb_catalog
cmdb_ci_db_mysql_catalog
cmdb_ci_file_system_smb
cmdb_ci_windows_service
DB2 Catalog
cmdb_ci_db_db2_catalog
Configuration Item
(cmdb_ci)
Computer Room
cmdb_ci_computer_room
Data Cemter
cmdb_ci_datacenter
Data Center Zone
cmdb_ci_zone
Rack
cmdb_ci_rack
4h
CMDB Physical Infrastructure Data Model Extensions
UPS
cmdb_ci_ups
UPS Output
cmdb_ci_ups_output
UPS Bypass
cmdb_ci_ups_bypass
UPS Alarm
cmdb_ci_ups_alarm
UPS Input
cmdb_ci_ups_input
Circuit
cmdb_ci_circuit
Outlet
cmdb_ci_pdu_outlet
Asset Data Model
5
Catalog
Item
Transfer
Order
sc_catalog_item
Hardware
Model
cmdb_hardware_pr
oduct_model
Transfer
Order
Line
Software
Model
cmdb_software_pro
duct_model
Depreciation
Product
Model
cmdb_product
Applic ation
Model
cmdb_application_pr
oduct_model
Stock Room
Rule
Model
Component
With the Aspen version and earlier the CMDB
was used for both CI and asset information.
This was accomplished by having two views
of the same record with different attributes
(and related lists) displayed
Asset View
(Financial Attributes)
- Assigned to
- Cost
- Purchase date
- PO number
- invoice number
- warranty expiry
Consumable Model
cmdb_consumable_
product_model
CI Class Specific View
(Configuration attributes)
- OS
- RAM
- Disk capacity
- Software version
And Relationship to other CI’s
- Depends on
- Used by
- DR provided by
Stockroom
Model
Category
cmdb_model_
category
Asset
Class
Asset
alm_asset
Hardware
Asset
alm_hardware
Software
Asset
alm_software
Company
core_company
Location
cmn_location
Cost
Center
cmn_cost_ce
nter
User
sys_user
SLA
Consumable
alm_consumable
Lease
Contract
Configuration
Item
cmdb_ci
The challenge with this
approach was it could not
handle CI’s that were not assets
(IP Networks) and Assets that
were not CI’s (toner cartridges,
desks, cubicles etc.)
With the Berlin version, a completely new set of tables
were created to separate asset records from
Configuration Items in the CMDB.
The Model Category enabled the auto-population of
the appropriate asset tables based on matching the CI
Class with the corresponding asset table (ie AIX Server
to Hardware Asset table)
When the asset record is created it is linked to the
corresponding CI record as are three fields by default
(assigned to, location and cost) When any of these
fields change in either table, the corresponding record
in the other table is automatically updated.
Service
Contract
Assets
Covered
Warranty
The Contract table has also been extended to
support different types of contracts
5a
Hardware Asset Data Model
CMDB CI Class
Asset Class
Model Category
cmdb_model_category
Manufacturer
Location
Hardware Model
cmn_location
cmdb_hardware_product_
model
Depreciation
Configuration
Item
Hardware
cmdb_depreciation
alm_hardware
core_company
cmdb_ci
Fixed Asset to
Asset
m2m_fixed_as
set_to_asset
Cost Center
cmn_cost_cener
Allocated to
Asset Entitlement
alm_entitlement_asset
Asset Covered
clm_m2m_contract_asset
Contract Model
cmdb_contract_product_mo
del
Contract Model
Contract
(ast_contract)
Licensed by
Software License
alm_license
5b
Software Asset Data Model
Asset Covered
clm_m2m_contract_asset
Software License
Calculation
Manufacturer
core_company
Software Discovery
Model
Contract
cmdb_sw_license_calculation
cmdb_sam_sw_discovery_model
ast_contract
Model Category
Software Model
cmdb_model_category
cmdb_software_product_model
Software
Installation
Software Counter
cmdb_sam_sw_install
sam_sw_counter
Software Usage
cmdb_sam_sw_usage
Software Counter
Result
sam_sw_counter_summary
Software Counter
Summary
sam_sw_counter_summary
Software Counter
Detail
Software License
sam_sw_counter_detail
alm_license
Installed on
Licensed by
Asset Entitlement
alm_entitlement_asset
Allocated to
Computer
Accessed
from
cmdb_ci_computer
User
User Entitlement
alm_entitlement_user
Assigned
to
User
sys_user
5c
Contract Data Model
Manufacturer
Service Contract
Cost Center
ast_service
cmn_cost_center
core_company
Product Model
Model Category
Vendor
cmdb_model
core_company
cmdb_model_category
Contract Model
Contract
User
ast_contract
sys_user
Contract Administrator
Asset Covered
Contract Used by
clm_m2m_contract_asset
Asset
Lease Instance
alm_asset
ast_contract_instancet
Configuration
Item
cmdb_ci
6a
Configuration Item
cmdb_ci
Asset
alm_asset
Computer
cmdb_ci_computer
Hardware Asset
alm_hardware
Model Management Data Model
Software Package
cmdb_ci_spkg
Software License
alm_license
Product Model
Hardware Model
Software Model
cmd b_prod uct_model
cmd b_hard wa re_prod uct_model
cmd b_software_prod uct_model
Consumable Asset
alm_consumable
Consumable Model
Application Model
cmd b_consumable_prod uct_model
cmd b_app lica tion_prod uct_model
Model Category
cmdb_model_category
6b
Model Management Table Extension
Configuration Item
cmdb_ci
Hardware
cmdb_ci_hardware
Software Package
cmdb_ci_spkg
Application
cmdb_ci_appl
Computer
cmdb_ci_computer
Asset
alm_asset
Hardware Asset
alm_hardware
Software License
alm_license
Consumable Asset
alm_consumable
Product Model
cmdb_model
Hardware Model
Software Model
Consumable Model
Application Model
cmd b_hard wa re_prod uct_model
cmd b_software_prod uct_model
cmd b_consumable_prod uct_model
cmd b_app lica tion_prod uct_model
7
IT Cost Management Data Model
A rate is defined to a specific task type (ie
routine change request costs $150
Task
Rate Card
Task
or
Task
Time
Worked
Labor
Rate Card
Incident has
a task time
worked for 1
hour
User
Defines which CIs to
distribute a distribution
cost to
Dis tribution
Rules
Costs to be distributed as
expense lines to multiple CIs
based on some logic
ie. Data center or Site
License costs
Dis tribution
Cos ts
Billable Rate
Business
Service
Expense is created
based on the fixed
fee based on task
rate card
Business
Service
Expense
Lines
Expense is created
based on the
workers bill rate or
fixed fee based on
task rate card
Generates
expense lines
for each CI
Based on
CMDB Relationship
aggregation
Used
by
Expense Allocations
Track capacity and
usage of business
services
Depends
on
Application
Runs on
Runs
Server
Expense
Lines
Allocation Defines how to
Rules
process expense
lines to assign them
to a business entity
Generated at
some interval (ie
monthly) based on
current CI Costs
Depart ment
Records representing a relationship between an
Expense
expense and any other record
Allocation
Cost
Center
Creates
Collection of cost related
entries associated to a
group of configuration items
Could define multiple types
(budget, forecast, actual
Asset
CI Rate
Card
Costs
Creates
CI
Rate Card
(template)
Configuration
Item
Fixed, recurring,
and depreciation
cost entries for a
individual CI or a CI
model
Creates
Assets
Covered
Contract
Contract
Rate Card
Associate a
budget to one
or more cost
centers
Cha rgebacks
Expense
Allocation
Summ aries
Snapshot of current
expenses for a business
service, by cost type
Used to allocate expenses
to cost centers or other
business entities
Budget
Track planned,
actual, and projected
expense allocations
Service Level Agreement Data Model
8
Service
Contract
Company
ast_service
(core_company)
User
Contract CI
Assets Covered
(contract_rel_ci)
(clm_m2m_contract_asset)
Contract Locations
Contract User
(contract_rel_location)
(contract_rel_user)
(sys_user)
Child
Contracts
Contract SLA
contract_rel_contract_sla
Configuration
Item
Task
(task)
cmdb_ci
Task SLA
SLA
task_sla
contract_sla
Asset
Location
User
Contract
alm_hardware
cmn_location
sys_user
ast_contract
Relative
Duration
cmn_relative_duration
Metric
Definition
metric_definition
cmdb_ci_service
Expense Line
(service_subscribe_location)
Schedule
Service
Offering
cmn_schuedule
SLA
Conditions
sla_condtion_class
Child Schedule
cmn_other_schedule
service_of fering
Referenced by
Service
Commitment
cmn_other_schedule
service_commitment
Schedule Entries
cmn_schuedule_span
fm_contract_rate_card
Business
Service
Metric Instance
metric_instance
Contract Rate
Card
Service
Offering SLA
Results
service_sla_result
(service_subscribe_sys_user)
fm_expense_line
Knowledge Management Data Model
9
KB
Submission
Task
Creates
task
kb_knowledge
Creates
User
sys_user
Source
Roles
sys_user_role
Knowledge
Article
Author
CMDB CI
kb_knowledge
Document
Knowledge Record
Knowledge Related to Products
dms_document
m2m_document_knowledge
m2m_kb_ci
Content Item
sc_cat_item_content
Knowledge Management Data Model Extensions
Knowledge
Article
Policy
grc_policiy
kb_knowledge
Task
task
KB
Submission
kb_knowledge
Knowledge
Feedback
Knowledge
Use
kb_feedback
kb_use
Configuration
Item
cmdb_ci
Knowledge Applied to Tasks
Task
m2m_kb_task
task
10a
Work Management Data Model
Company
(Primary)
Company
(Customer)
core_company
core_company
User
Location
sys_user
Department
Vendor
cmn_department
core_company
User
(Caller)
cmn_location
Service
Contract
sys_user
ast_contract
Has roles
Roles
sys_user_role
Has Skills
Groups covering:
Qualifier
Dispatch
Assignment
(sys_group_covers_location)
(sys_user_has_skill)
Work Order
Task SLA
SLA
Contract SLA
(task_sla)
contract_sla
(contract_rel_contract_sla)
wm_order
Has roles
Asset Covered
Is member of
(clm_m2m_contract_asset)
A rate is defined to a specific task type (ie
routine move task costs $150
(sys_user_grmember)
Group
sys_group
Task
Rate Card Expense is created
based on the fixed
or fee based on task
rate card
Work Task
Skills
wm_task
Group has
skills
cmn_skill
Affected CI
(wm_m2m_order_affected_ci)
Affected CI
(wm_m2m_order_affected_ci)
Model Category
cmdb_model_category
Configuration
Item
cmdb_ci
Product
Model
Task Time
Worked
Part
Requirement
task_time_worked
wm_part_requirement
Asset Usage
cmdb_model
wm_asset_usage)
User
(sys_user)
Asset
alm_asset
Labor
Rate Card
Expense is created
based on the
Billable workers bill rate or
Rate fixed fee based on
task rate card
Transfer Order
Location
Expense
Lines
alm_transfer_order
cmn_location
fm_expense_line
Transfer
Order Line
(alm_transfer_order
_line)
From
To
Stockroom
alm_stockroom
Stockroom
Type
alm_stockroom_type
10b
Work Management Group Data Model
Group
(Initiator)
Group
(Qualifer)
sys_user_group
sys_user_group
Group
(Dispatcher)
sys_user_group
Locations
Covered
Locations
Covered
Dispatches Work Group
(wm_m2m_group_dependency)
Covered by Dispatch Group
Locations
Covered
Group
(Work)
sys_user_group
Location
Locations
Covered
cmn_location
Has Skills
(sys_group_has_skill)
Is member of
(sys_user_grmember)
Has roles
(sys_group_has_role)
Department
cmn_department
User
sys_user
Reports to
Skill
Has Skills
cmn_skill
(sys_user_has_skill)
Contained Skills
(cmn_skill_contains)
Has roles
Roles
(sys_user_has_role)
sys_user_role
8
IT Governance, Risk & Compliance Data Model
Entity
grc_entity
Authoritative
Source
(ast_service)
m2m_policy_entity
m2m_policy_authoritative_source
m2m_auth_src_con_auth_src_con
Policy
Authoritative Source
Content
m2m_policy_auth_src_content
grc_authoritative_src_content
grc_policy
m2m_risk_policy
Audit Definition
Requirements
m2m_control_policy
contract_sla
m2m_control_auth_src_content
m2m_audit_def_requirement
Risks
grc_risk
m2m_risk_control
Controls
Audit Instances
grc_control
grc_audit
Creates
Audit Definition
grc_audit_definition
Risk Criteria
grc_risk_criteria
Control Test
Definition
grc_control_test_definition
Creates
Risk Approach
Rules
grc_risk_approach_rules
Condition
Collections
grc_condition_collection
Control Test
Instance
grc_control_test
Conditions
grc_condition
Remediation
grc_remediation
Audit
Observations
grc_observation
Requirements
grc_audit_requirement
12a Project & Portfolio Management Data Model
Porfolio
Projects
pm_portfolio
Portfolio
Projects
(deprecated)
Project SLA
Project
pm_project_sla
pm_project
Project View
pm_m2m_portfolio_project
Project Metric
pm_project_metric
Portfolio Project
Project Task
SLA
Project Task
pm_portfolio_project
pm_project_task_sl
a
pm_project_task
Project Task
Metric
Successor
pm_project_task_m
etric
Predecessor
Goal
goal
Actual
Goal
Portfolio Project
Goal
pm_portfolio_goal
Planned Task
Relationships
planned_task_rel_plann
ed_task
Project Task
Link
pm_project_task_link
Risk
risk
Actual
Risk
Portfolio Project
Risk
pm_portfolio_risk
Portfolio Project
Group
pm_portfolio_group_res
ource
Group Resource
group_resource
Change Request
Portfolio Project
Issue
pm_portfolio_issue
Portfolio Project
Resource
pm_portfolio_user_reso
urce
change_request
User Resource
user_resource
Time Card
time_card
Task Time
Worked
task_time_worked
12b
Resource Management Data Model
User
sys_user
Task
task
Has roles
Roles
sys_user_role
Has roles
Is member of
or
sys_user_grmember
Resource
Plan
resource_plan
Group
Task Time
Worked
task_time_worked
Resource
Allocation
Resource
Report
resource_report
resource_allocation
Time Card
time_card
Type
Resource
Event
resource_event
13
Structured Problem Analysis (powered by Kepner-Tregoe)
Incident
Problem
incident
problem
Source
Source
Confirmation
method
Problem
Analysis
kt_cause_confirmation
_method
kt_problem_analysis
Specify
Problem
kt_problem_area
Distinction &
Change
Cause
Cause
Evaluation
kt_cause
kt_distinctions_changes
kt_cause_evaluation
WHAT
What Object
kt_01_what_object
What Deviation
kt_02_what_deviation
WHERE
Where
Geographically
kt_03_where_geograp
hically
Where On
Object
kt_04_where_object
WHEN
EXTENTS
How Many
Objects
When First
kt_05_when_first
kt_08_extent_objects
When Since
What Is The Size
kt_09_extent_size
kt_06_when_since
When In Life
Cycle
How Many
Deviations
kt_10_extent_deviations
kt_07_when_lifecycle
What Is The
Trend
kt_11_extent_trend
Connector from bottom indicates
link to another table through
Related Lists
This line type Indicates a
self referential link from a
record in user table to
another record in the same
table
(ie Manager)
Department
User
Border & connecting line indicate method of record
creation in CMDB:
C
CE
Discoverable by ServiceNow Discovery
Manually input (or imported)
Must first configure CI Classifier then can discovered
Populated by BDNA Technopedia integration
Calculated based on other values in ServiceNow
Calculated based on external alerts received
Exchange
Application
This line type indicates a one-to -many
relationship
(ie. a department can have many users but a
user can only be linked to one department)
Connector to side or top indicates link to
another table through field on the form
This line type indicates extending a table.
When a table is extended from another
table, a new view is created with all the
fields of the parent. Additional fields can be
added to the extended table without
affecting the parent
Reports to
Has roles
Note: the text color matches that of the other Data Model
Roles
Printer
Instance
Runs
This line type indicates a many-to-many
relationship using an intermediary M2M table
(ie. user can have multiple roles and each role
can be assigned to multiple users)
Task
- Opened by
- Assigned to
- Assignment Group
- Company
Indicates fields referenced from this
data model to other data models (ie the
Task table references fields in the
Organizational Data Model)
Runs on
Incident
Example
names in
red
Objects with no
color or light
green are
supporting
tables not
extended from
CMDB data
model
Record
Producer
Server
This line type indicates a
Upstream CI Relationship.
There will be a reciprocal CI
Relationship for
Downstream
Creates
Incident
Problem
- Opened by
- Assigned to
- Assignment Group
- Company
- Caller
- Category
This line type Indicates another record is
created as a result of a UI Action, Business
Rule or Workflow