Operational Status field for Virtual Machines 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 : Virtual Machine Instance [cmdb_ci_vm_instance] Server [cmdb_ci_server] Linux Server [cmdb_ci_linux_server] Windows Server [cmdb_ci_win_server] Field used to represent operational status : operational_status Flow of data into this field for Virtual Machine Instance class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_virtual_machine, 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=efebd0a6a32d4e10154e77cec31e6106 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 applicable to populate the operational status value for the Server, Windows Server and Linux Server 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_virtual_machine" 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