Table: servicenow_sn_chg_rest_change_impacted_cmdb_ci_service - Query ServiceNow Change Impacted CMDB CI Services using SQL
ServiceNow Change Management is a service that allows organizations to manage IT changes systematically so that they can negotiate change effectively. It provides a structured approach to control the lifecycle of all changes, facilitating beneficial changes to be made with minimum disruption to IT services. This includes managing changes to the Configuration Management Database (CMDB) and tracking impacted services.
Table Usage Guide
The servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
table provides insights into the impacted configuration item services associated with a change in ServiceNow's Change Management module. As a Change Manager, you can use this table to track and analyze the impact of changes on different services, helping to minimize disruptions and ensure a smooth change implementation process. This table is especially useful for identifying dependencies and potential risks associated with changes to the CMDB.
Examples
How many CMDB CI Services are impacted by each change?
Determine the total number of Configuration Item (CI) Services impacted by each change. This helps in understanding the extent of the impact each change has on services, enabling better change management and mitigation planning.
select task_name, count(cmdb_ci_service_sys_id) as num_ci_impactedfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by task_nameorder by num_ci_impacted desc;
select task_name, count(cmdb_ci_service_sys_id) as num_ci_impactedfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by task_nameorder by num_ci_impacted desc;
What is the total number of manually added changes in the table?
Assess the extent of manual interventions in the change management process. This query helps in identifying the total number of changes that were manually added, providing insights into the degree of human involvement in the change management process.
select count(*)from servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere manually_added = true;
select count(*)from servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere manually_added = 1;
Which CMDB CI Services were impacted by a specific change?
Explore which Configuration Management Database (CMDB) services were impacted by a specific change. This is useful in assessing the scope and potential impact of changes, helping to manage risk and ensure continuity of services.
select cmdb_ci_service_name, task_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere task_name = 'CHG0000060';
select cmdb_ci_service_name, task_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere task_name = 'CHG0000060';
Which change impacted a specific CMDB CI Service?
Determine the specific tasks that impacted a particular Configuration Management Database (CMDB) service. This is useful in identifying changes that may have caused issues or disruptions in the service.
select task_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere cmdb_ci_service_sys_id = '2216daf0d7820200c1ed0fbc5e6103ca';
select task_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere cmdb_ci_service_sys_id = '2216daf0d7820200c1ed0fbc5e6103ca';
What is the total number of changes that impacted each CMDB CI Service?
Discover the segments that have been most impacted by changes, by assessing the total count of changes per service. This can help prioritize areas for review and potential improvement.
select cmdb_ci_service_name, count(task_name) as num_changesfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by cmdb_ci_service_nameorder by num_changes desc;
select cmdb_ci_service_name, count(task_name) as num_changesfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by cmdb_ci_service_nameorder by num_changes desc;
Who created the most changes in the table?
Analyze the frequency of modifications to understand who has made the most changes. This can be useful for assessing individual workload or identifying frequent contributors in a collaborative environment.
select sys_created_by, count(*) as num_changes_createdfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by sys_created_byorder by num_changes_created desc;
select sys_created_by, count(*) as num_changes_createdfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by sys_created_byorder by num_changes_created desc;
Which changes were added manually?
Explore which changes were made manually to your services. This can be useful to identify any potential unauthorized changes or inconsistencies in your system.
select task_name, cmdb_ci_service_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere manually_added = true;
select task_name, cmdb_ci_service_namefrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicewhere manually_added = 1;
What is the most common task in the table?
Discover the most frequently occurring task within your service operations by using this query. This could be beneficial in identifying patterns, optimizing workflows, or allocating resources more effectively.
select task, task_name, count(*) as num_tasksfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by task, task_nameorder by num_tasks desclimit 1;
select task, task_name, count(*) as num_tasksfrom servicenow_sn_chg_rest_change_impacted_cmdb_ci_servicegroup by task, task_nameorder by num_tasks desclimit 1;
What is the average number of CMDB CI Services impacted by each change?
Analyze the impact of each change to understand the average number of Configuration Item (CI) Services affected. This information can be used to assess the potential disruption caused by changes and plan accordingly.
select avg(num_ci_impacted) as avg_num_ci_impactedfrom ( select task_name, count(cmdb_ci_service_sys_id) as num_ci_impacted from servicenow_sn_chg_rest_change_impacted_cmdb_ci_service group by task_name ) as subquery;
select avg(num_ci_impacted) as avg_num_ci_impactedfrom ( select task_name, count(cmdb_ci_service_sys_id) as num_ci_impacted from servicenow_sn_chg_rest_change_impacted_cmdb_ci_service group by task_name );
Schema for servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
cmdb_ci_service_name | text | Name of the CMDB CI service impacted by the change. | |
cmdb_ci_service_sys_id | text | System ID of the CMDB CI service impacted by the change. | |
manually_added | boolean | Indicates whether the CMDB CI service was manually added to the change. | |
sys_created_by | text | User who created the record. | |
sys_created_on | timestamp with time zone | Date and time when the record was created. | |
sys_id | text | Unique system identifier for the record. | |
sys_mod_count | bigint | Number of times the record was modified. | |
sys_tags | text | Tags associated with the record. | |
sys_updated_by | text | User who last updated the record. | |
sys_updated_on | timestamp with time zone | Date and time when the record was last updated. | |
task | text | Task associated with the impacted CMDB CI service. | |
task_name | text | Name of the task associated with the impacted CMDB CI service. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- servicenow
You can pass the configuration to the command with the --config
argument:
steampipe_export_servicenow --config '<your_config>' servicenow_sn_chg_rest_change_impacted_cmdb_ci_service