turbot/servicenow
steampipe plugin install servicenow

Table: servicenow_sn_chg_rest_change_model - Query ServiceNow Change Models using SQL

ServiceNow Change Models provide a pre-defined and standardized method to handle changes in the IT infrastructure. They are used to manage and track changes in a systematic and repeatable way. Change Models contain detailed steps and procedures that should be followed while implementing a change.

Table Usage Guide

The servicenow_sn_chg_rest_change_model table provides insights into Change Models within ServiceNow. As a Change Manager, you can explore model-specific details through this table, including model identifiers, names, and descriptions. Use this table to understand the various change models available, their purposes, and steps involved in their implementation.

Examples

Get the name and description of all change models, ordered by name

Explore the various change models in your system, sorted by their names. This can be useful in understanding the different types of changes that can occur and planning accordingly.

select
name,
description
from
servicenow_sn_chg_rest_change_model
order by
name;
select
name,
description
from
servicenow_sn_chg_rest_change_model
order by
name;

Get all the active change models available in the UI

Explore which change models are currently active and available for use within the user interface. This allows you to understand which models are accessible for implementing changes, aiding in efficient change management.

select
*
from
servicenow_sn_chg_rest_change_model
where
active = true
and available_in_ui = true;
select
*
from
servicenow_sn_chg_rest_change_model
where
active = 1
and available_in_ui = 1;

Get the default change model

Explore which change models are set as default in your ServiceNow configuration. This can be useful in understanding and managing your change process effectively.

select
*
from
servicenow_sn_chg_rest_change_model
where
default_change_model = true;
select
*
from
servicenow_sn_chg_rest_change_model
where
default_change_model = 1;

Get the number of times each change model has been modified

Analyze the frequency of modifications to each change model to understand the most frequently updated ones. This can help identify areas of frequent change, potentially highlighting areas for process improvement.

select
name,
sys_mod_count
from
servicenow_sn_chg_rest_change_model
order by
sys_mod_count desc;
select
name,
sys_mod_count
from
servicenow_sn_chg_rest_change_model
order by
sys_mod_count desc;

Schema for servicenow_sn_chg_rest_change_model

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
activebooleanFlag that indicates whether the associated change model record is active and available within the instance.
available_in_uibooleanFlag that indicates whether the associated change model record is available within the user interface.
colortextColor of the associated change model on the change request landing page.
default_change_modelbooleanFlag that indicates whether the associated change model record is the default change model.
descriptiontextShort description of the purpose of the change model.
nametextName of the change model.
record_presettextName-value pairs of the fields that should automatically be populated, with their associated values, when a new change request record is created. Values are separated by caret symbols.
state_fieldtextChoice list field from which to collect choices, based on the provided in table_name.
sys_class_nametextChange module table name. Always Change Model/chg_model.
sys_created_bytextName of the user that initially created the associated change module record.
sys_created_ontextDate and time that the change module record was originally created.
sys_domaintextIf using domains in the instance, the name of the domain to which the change module record is associated.
sys_domain_pathtextIf using domains in the instance, the domain path in which the associated change module record resides.
sys_idtextUnique identifier of the associated change model record.
sys_mod_countbigintNumber of times that the associated change model record has been modified.
sys_nametextName of the change model. Always the same as the
sys_tagstextSystem tags associated with the change model record.
sys_updated_bytextName of the user that last updated the associated change model record.
sys_updated_ontextDate and time the associated change model record was last updated.
table_nametextTable that defines the Choice list field from which to collect choices. For change models this is always set to 'change_request'.

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_model