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, descriptionfrom servicenow_sn_chg_rest_change_modelorder by name;
select name, descriptionfrom servicenow_sn_chg_rest_change_modelorder 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_modelwhere active = true and available_in_ui = true;
select *from servicenow_sn_chg_rest_change_modelwhere 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_modelwhere default_change_model = true;
select *from servicenow_sn_chg_rest_change_modelwhere 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_countfrom servicenow_sn_chg_rest_change_modelorder by sys_mod_count desc;
select name, sys_mod_countfrom servicenow_sn_chg_rest_change_modelorder by sys_mod_count desc;
Schema for servicenow_sn_chg_rest_change_model
Name | Type | Operators | 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