Operational Status field for Scale Set VMs 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 Virtual Machines" that populates various fields in below two CI classes : Cloud Mgmt Network Interface [cmdb_ci_nic] Storage Volume [cmdb_ci_storage_volume] Server [cmdb_ci_server] Windows Server [cmdb_ci_win_server] Linux Server [cmdb_ci_linux_server] Virtual Machine Instance [cmdb_ci_cm_instance] Field used to represent operational status : operational_status Flow of data into this field for Cloud Mgmt Network Interface class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_scale_sets_vms, using the data loader script. 2. The value of the nested JSON attribute properties.networkProfile.networkInterfaces[*].nicOperationalStatus is used to populate operational_status field for Cloud Mgmt Network Interface record. Flow of data into the field for Storage Volume class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_scale_sets_vms, 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 Virtual Machine Instance record. https://<instance>.service-now.com/nav_to.do?uri=sys_rte_eb_script_operation.do?sys_id=07d213e5a35e8690154e77cec31e611b 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". The same flow is applicable to populate the operational status value for the Server, Windows Server, Linux Server and Virtual Machine Instance records. 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_vms" table, for the value of operationalStatus attribute. If the value of the attribute 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