title | description |
---|---|
Steampipe Table: servicenow_sn_chg_rest_change_impacted_cmdb_ci_service - Query ServiceNow Change Impacted CMDB CI Services using SQL |
Allows users to query Change Impacted CMDB CI Services in ServiceNow, providing detailed information about impacted configuration item services associated with a change. |
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.
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.
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_impacted
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
task_name
order by
num_ci_impacted desc;
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
order by
num_ci_impacted desc;
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_service
where
manually_added = true;
select
count(*)
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
manually_added = 1;
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_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
task_name = 'CHG0000060';
select
cmdb_ci_service_name,
task_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
task_name = 'CHG0000060';
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_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
cmdb_ci_service_sys_id = '2216daf0d7820200c1ed0fbc5e6103ca';
select
task_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
cmdb_ci_service_sys_id = '2216daf0d7820200c1ed0fbc5e6103ca';
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_changes
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
cmdb_ci_service_name
order by
num_changes desc;
select
cmdb_ci_service_name,
count(task_name) as num_changes
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
cmdb_ci_service_name
order by
num_changes desc;
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_created
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
sys_created_by
order by
num_changes_created desc;
select
sys_created_by,
count(*) as num_changes_created
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
sys_created_by
order by
num_changes_created desc;
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_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
manually_added = true;
select
task_name,
cmdb_ci_service_name
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
where
manually_added = 1;
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_tasks
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
task,
task_name
order by
num_tasks desc limit 1;
select
task,
task_name,
count(*) as num_tasks
from
servicenow_sn_chg_rest_change_impacted_cmdb_ci_service
group by
task,
task_name
order by
num_tasks desc limit 1;
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_impacted
from
(
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_impacted
from
(
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
);