Query: What is the average number of CMDB CI items affected by each change?

Description

Determine the average number of Configuration Items (CI) impacted by each change in your ServiceNow change management process. This can help in assessing the potential impact and risk of changes, aiding in better change planning and management.

Query

Tables used in this query:

• servicenow_sn_chg_rest_change_affected_cmdb_ci

SQL