Using the flexible data model
Summarize
Summary of Using the Flexible Data Model
The flexible data model, introduced in Operational Resilience Release 21.0.x, enhances operational resilience metrics by improving data visualization and the flow of dependent services. It supports multiple dashboards that provide insights into critical areas such as red flags, business service importance, and impact tolerance, thereby enabling better decision-making and management of dependencies.
Show less
Key Features
- Enhanced Data Visualization: The model includes a vertical layout for Services, Business Services, Offerings, Business Processes, and Application Services, allowing users to easily navigate the Operational Resilience Workspace and view resilience metrics for selected objects.
- Streamlined Navigation: Users can quickly access related lists and metrics for specific business services, facilitating faster data retrieval and analysis.
- Optimized Data Management: Each node within the hierarchical chain is stored separately in the [snoperresprofile] table, which allows for improved efficiency by only retaining relevant entities.
- Configurable Top Class: The snoperres.topclassname property lets users designate any class as the top class in dashboard views, enabling flexible data presentation across different object types.
- Calculation and Roll-Up of Red Flags: The dashboard reflects real-time updates on red flags, including detailed breakdowns for individual business services, improving monitoring and response capabilities.
Key Outcomes
By utilizing the flexible data model, ServiceNow customers can expect improved operational resilience through optimized data flow and visualization, leading to enhanced decision-making. The streamlined approach reduces complexity in data retrieval and management, while the configurable dashboard allows for tailored views based on organizational needs. The scheduled jobs for updating CSDM and calculating red flags ensure that data remains current, facilitating proactive management of business services and their dependencies.
Starting with Operational Resilience, Release 21.0.x, the flexible data model enhances operational resilience metrics by improving data visualization and the flow of dependent services. It also supports multiple dashboards with insights into red flags, business service importance, and impact tolerance.
Starting with Operational Resilience, Release 20.1.x, the Main node configurations, supported by the Data Relationships Framework, were introduced with Operational Resilience to define dependency roll-up chains. The Main node configurations, with the source being the OpRes CMDB, are shipped out-of-the-box. For information on the Main node configurations, creating a new Main node configuration, or updating an existing Main node configuration, see Main node configurations: A component of the Data Relationships Framework.
In the previous data model, the CSDM objects [sn_oper_res_profile] table stored the entire dependency chain, including all possible combinations, making data retrieval cumbersome and maintenance challenging. This approach has been deprecated in favor of a more efficient model.
Key features of the flexible data model
The flexible data model offers several key features that enhance operational resilience metrics.
- Enhanced data visualization: The Services, Business services, Offerings, Business processes, and Application services modules now feature a vertical layout, replacing traditional horizontal tabs and enhancing navigation within the Operational Resilience Workspace. You can view the entire resilience metrics for an object, such as a business process or business service, from the Overview tab in the vertical layout.
You can then view the downstream data and various dashboards based on the selected top class. The following example shows the top controls to be strengthened for the business service.
Selecting the graph shows detailed information on the dependency records, related controls, control objectives.
- Streamlined navigation: You can directly access related lists and metrics for a specific business service, such as its service offerings, business processes, application services, dependencies, incidents, and metrics from the vertical layout.
Technical implementation
Starting with Operational Resilience, Release 21.0.x, the data model for operational resilience configurations has been optimized. Now, each node in a hierarchical chain, such as a business service to offering to processes, is stored separately in the [sn_oper_res_profile] CSDM objects table along with its class and parent nodes. This means that only relevant objects (for example, 500 out of 1,000 entities) that are part of main node configurations are stored, improving data management efficiency.
The flexible data model introduced with Operational Resilience, Release 21.0.x provides a foundation for the dashboards and tracks the flow of dependent services. The data, including red flags by type, such as failed controls, incidents, and outages, and business service metrics such as number of flags, importance, and impact tolerance, is updated in the dashboard through changes to the flexible data model.
The data shown in the example is for business services such as business service by number of red flags, business service by importance, business service by impact tolerance. You can configure the sn_oper_res.top_class_name property to designate any class as the top class.
Configuring the sn_oper_res.top_class_name property
You can configure the sn_oper_res.top_class_name property to designate any class as the top class in the dashboard view so that any node, such as business service, business process, or application service, can be the top node. You can then view the downstream data and various dashboards based on the selected top class, such as the number of application services that are under a business service. It enables you to switch between different views, such as business services, service offerings, business processes, or applications, on the dashboard and view relevant data accordingly.
For example, if the data is displayed for a business service, you can change the top class to service offerings, business processes, or application services by configuring the sn_oper_res.top_class_name property. You can then change the top class to another object and the system shows data with respect to that specific top class. This property is applicable only for the dashboards and not for the Workspace forms. For more information on the properties, see Configure Operational Resilience properties.
The following example shows that the top class name is set to cmdb_ci_service_business.
You can modify the property value to represent a service offering or application, and the dashboard will populate with the corresponding data. The following example demonstrates how to update the top class name to "service offering."
Based on the updated property name, data for service offering is displayed in the Operational Resilience dashboard as shown in the example.
Calculation and roll-up of red flags
When the Calculate red flags for CSDM and dependencies scheduled job is executed, the red flags data is populated in the dashboard. The dashboard in the following example displays a range of 1-30 red flags in the "Business service by number of red flags" section.
Selecting the card shows a detailed breakdown for the business service. It shows a total of 24 red flags, with 3 specifically attributed to the "Cards and payments" service. The following illustration shows the roll-up functionality, which aggregates the red flags for the entities associated with the selected "Cards and Payments" business service, providing a hierarchical view of the data.
The value "24" shown in the Total red flags count column is the roll-up value of the red flags for all entities under the "Cards and Payments" business service.
CSDM objects table
- The Impacted objects column displays the parent objects.
- The Impacted objects classes column shows the classes.
- The Red flags count column indicates the number of the red flags that are directly assigned to a node.
- The Total red flags count column displays the total count of the red flags directly assigned to a node and its children as shown in the table.
The object classes displayed in the Object class column in the example provide a clear representation of various entities, including business applications and processes. This data is then fed into the system using fix scripts, ensuring that the information is accurately populated and up-to-date. By using these scripts, the system can effectively display and manage the complex relationships between different object classes.
You can group the objects with respect to their object classes. Then you can the object classes for service offerings, core company, business processes, and so on.
The upstream impacted objects for a specific object class are added to the Impacted objects column. For example, the Java Application Server FLX has upstream impacted objects such as digital banking process and inbound payment, which get added and are shown in the Impacted objects column.
This process starts with the lowest level object and includes the level above it, populating the impacted objects. The data is then directly integrated into the main node configurations.
Main node configurations
- Business process to dependencies
- Business service to dependencies
- Opres with CSDM header
- Service (CMDB)
- Service offering to dependencies
The entire flow that goes from a business service to business process to service offering and then to an application is created in the Main node configurations and then the configurations are mapped to the impacted objects.
For information on setting up the Main node configurations, see Configure the Main node configurations.
Running the scheduled jobs
Two scheduled jobs, Update CSDM and other dependencies and Calculate red flags for CSDM and dependencies run at regular intervals populate data in the CSDM objects [sn_oper_res_profile.list] table and the red flags. For more information, see Execute the scheduled jobs.
All the Main node configurations are handled in parallel. A separate event is triggered for each Main node configuration, enabling parallel processing. The enhanced configuration eliminates the need for sequential processing, significantly improving efficiency.
After running the Update CSDM and other dependencies scheduled job, the data is fetched into the CSDM Objects table. Dependencies are updated for the objects and are shown in the modules.
Previously, traversing many-to-many tables to find related records was time-consuming. Now, by storing impacted objects in the table itself, you can directly retrieve related records from a single column, eliminating the need for recursive hierarchy creation, improving efficiency significantly.
Dependencies are fetched from the Entity [sn_grc_profile] (many-to-many) table first. When you run the Calculate red flags for CSDM and other dependencies scheduled job, the red flags data is fetched and rolled up according to the configured settings.
After the scheduled job is completed, the Main node configurations are no longer required. The dashboard uses the top class property to traverse the red flags staging table and retrieve downstream red flags that match the specified record type, such as business service or service offering, and so on.
The following example shows that Incident SO1 - VM is rolled up from SO1.
Failed controls from business processes and service offerings are rolled up and shown in the modules.