Query: How many CMDB CI items are affected by each change?

Description

Determine the impact of each change on your Configuration Management Database (CMDB) by identifying the number of Configuration Items (CI) affected by each task. This can help prioritize tasks based on the scale of their impact.

Query

Tables used in this query:

• servicenow_sn_chg_rest_change_affected_cmdb_ci

SQL