Operational Status field for Scale Sets imported from Service Graph connector for Microsoft AzureSummary<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Service Graph Connector is shipped with a data source "SG-Azure Scale Sets" that populates various fields in Instance Scale Set [cmdb_ci_instance_scale_set] class Field used to represent operational status : operational_status Here is the flow of data into this field for Instance Scale Set class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_scale_sets, using the data loader script. 2. Data in the staging is in a nested JSON format. RTE script operation below checks for the value of attribute properties.provisioningState for a Resource Group record. https://<instance>.service-now.com/nav_to.do?uri=sys_rte_eb_script_operation.do?sys_id=0cd3c228a36a0ad0154e77cec31e614f 3. If the value of provisioningState attribute is "Deleting", the value of Operational Status field is set to "Retired". 4. If the value of provisioningState attribute is "Succeeded", the value of Operational Status field is set to "Operational". If there is an issue reported for populating Operational Status field, review the nested JSON payload in data field of "sn_sg_azure_integ_scale_sets" table, for the value of provisioningState attribute. If the value above is correct, run the RTE operation script in the background scripts with appropriate inputs to review the output of RTE operation. If the output of the script is correct, capture the IRE input payload generated by the transform map, and run the simulation.to see if IRE is not able to update the Operational Status field. Refer KB0750382 to know how to isolate impacted row from the import set. Refer KB0793220 to know how to run IRE simulation on a given payload generated by RTE transformation. Related Links<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } https://www.servicenow.com/docs/bundle/yokohama-servicenow-platform/page/product/configuration-management/concept/cmdb-integration-azure.html