CMDB schema model
Summarize
Summary of CMDB schema model
The CMDB schema model in ServiceNow is a structured set of interconnected tables that store detailed information about all assets and business services managed by an organization, along with their configurations. It serves as the foundation for understanding and managing the configuration items (CIs) within your IT environment. The CMDB supports better network visibility and relationship mapping between devices, which is essential for IT operations and other dependent applications such as Asset Management and Contract Management.
Show less
Key Features
- Comprehensive Data Storage: CMDB tables include records on computers, devices, software licenses, business services, and network components.
- Class Hierarchy and Extensions: The CMDB uses a hierarchy of classes starting from the Base Configuration Item [cmdb] to specialized classes like Computers, Servers, UNIX Servers, Databases, and Network Devices. This classification supports detailed tracking and management of different asset types.
- Principal Class Designation: Important classes such as servers, databases, network devices, application servers, and storage can be designated as Principal Classes to prioritize their monitoring and maintenance.
- Role-Based Access: Access to core tables like Configuration Item [cmdbci] requires specific roles such as sncmdbadmin, sncmdbeditor, asset, admin, or itil user roles, ensuring controlled data management.
- Relationship Management: The CI Relationship [cmdbrelci] class defines dependencies and connections between different CIs, which is critical for impact analysis and troubleshooting.
- Extensibility and Custom Attributes: You can extend existing classes to add unique attributes or create new classifications, allowing the CMDB to adapt to your organization’s specific needs.
- Schema Visualization: The schema map tool within ServiceNow lets you view table structures and their relationships, aiding in understanding and customizing the CMDB schema.
- Supporting Applications and Apps: Integration with ServiceNow Store apps enhances CMDB capabilities with advanced class models, discovery patterns, and connectors for third-party data ingestion.
Practical Use and Benefits
By leveraging the CMDB schema model, ServiceNow customers can achieve:
- Improved visibility into IT assets and their relationships, supporting efficient incident management and root cause analysis.
- Streamlined asset and contract management through linked data on hardware, software, leases, warranties, and service contracts.
- Enhanced configuration management processes by maintaining an accurate and adaptable record of all configuration items.
- Better operational control and decision-making by focusing on critical IT classes designated as Principal Classes.
- Flexibility to extend the CMDB schema as organizational needs evolve, ensuring the database remains relevant and comprehensive.
The CMDB schema model is a series of connected tables that contain all the assets and business services controlled by a company and its configurations.
- CMDB tables descriptions: Descriptions of key CMDB tables in the base system.
- CMDB CI Class Models: A ServiceNow Store app that adds class models that extend the base CMDB class hierarchy. This includes class descriptions, identification rules, identifier entries, and dependent relationships if applicable. You can then use the added classes as any other CMDB base class.
- Populating the CMDB: Information about the various options for populating the CMDB.
- Discovery patterns: A ServiceNow Store app that provides a library of Discovery patterns for discovering specific devices and applications in the industry.
- Getting started with Service Graph Connectors: ServiceNow Store apps that provide pre-defined integrations for importing and integrating common third-party data into CMDB classes. Also includes the IntegrationHub ETL wizard for creating new ETL transform maps.
CMDB tables contain information about computers and devices on the network, software contracts and licenses, business services, and so on. The IT desk can use the CMDB to better understand their network users' equipment, and the relationships between them. The CMDB can also be referenced by other processes within the system.
Applications such as Asset Management and Contract Management, operate in conjunction with the CMDB. Asset Management and Software Asset Management link to CMDB all assets, hardware, software, assets in stock, as well as records for manufacturers and vendors. The Contract Management application contains information about contracts, including leases, service contracts, purchase orders, warranties, and software licenses. The Configuration Management Database (CMDB) application has a focus on operation.
For more background information about the CMDB, see the ServiceNow Community post at CMDB 101- What is a configuration management database and why do you need one?.
Key class categories
- Servers (physical and virtual): Classes that are typically well-understood, relatively stable, and which form the backbone of most infrastructure.
- Databases: Classes of high business impact, critical for incident triage, and relatively straightforward to discover and maintain.
- Network devices (core infrastructure): Classes such as routers, switches, firewalls, and load balancers—hardware that connects everything. If setting as Principal Class, then as a general guideline, prioritize core and critical devices over access switches.
- Application servers.
- Storage.
Key CMDB classes
Key classes in the CMDB:
- The Base Configuration Item [cmdb] class, which is the core CMDB table for non IT CIs (descending classes are non IT CIs).
- The core Configuration Item [cmdb_ci] class, which stores the basic attributes of all the CIs. The sn_cmdb_admin, sn_cmdb_editor, asset, admin, or itil user role is required to access this table (descending classes are IT CIs).
- The CI Relationship [cmdb_rel_ci] class, which defines all relationships between CIs.
The Configuration Item class is extended to other classes, such as Database [cmdb_ci_database] and Computer [cmdb_ci_computer]. The Computer class is extended to the Server [cmdb_ci_server] class, which is extended to the UNIX Server [cmdb_ci_unix_server] class, and so on.
- Navigate to .
- Select a table and then select Schema Map.
CI attributes
Attributes apply to all the CIs in a classification. To change attribute values for a CI, edit the appropriate CI. To add a unique attribute to a class, extend the class table and create a new classification for that CI.
The position of a CI in a classification hierarchy is determined by the attributes it shares with the CIs below it. Each time a CI has a single different attribute from its parent, the classification hierarchy branches.
For example, servers have different attributes from computers, which include workstations and laptops. Linux servers and UNIX servers have different attributes from the parent server classification and from each other, so they occupy separate branches in the hierarchy.