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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
active	boolean	Flag that indicates whether the associated change model record is active and available within the instance.
available_in_ui	boolean	Flag that indicates whether the associated change model record is available within the user interface.
color	text	Color of the associated change model on the change request landing page.
default_change_model	boolean	Flag that indicates whether the associated change model record is the default change model.
description	text	Short description of the purpose of the change model.
name	text	Name of the change model.
record_preset	text	Name-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_field	text	Choice list field from which to collect choices, based on the provided in table_name.
sys_class_name	text	Change module table name. Always Change Model/chg_model.
sys_created_by	text	Name of the user that initially created the associated change module record.
sys_created_on	text	Date and time that the change module record was originally created.
sys_domain	text	If using domains in the instance, the name of the domain to which the change module record is associated.
sys_domain_path	text	If using domains in the instance, the domain path in which the associated change module record resides.
sys_id	text	Unique identifier of the associated change model record.
sys_mod_count	bigint	Number of times that the associated change model record has been modified.
sys_name	text	Name of the change model. Always the same as the
sys_tags	text	System tags associated with the change model record.
sys_updated_by	text	Name of the user that last updated the associated change model record.
sys_updated_on	text	Date and time the associated change model record was last updated.
table_name	text	Table 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