Operational Status field for Public IP Addresses 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 Public IP Address" that populates various fields in below two CI classes : Cloud LB IPAddress (cmdb_ci_cloud_lb_ipaddress) Cloud Public IP Address (cmdb_ci_cloud_public_ipaddress) Field used to represent operational status : operational_status Here is the flow of data into this field for Cloud LB IPAddress class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_public_ip_address, 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 Cloud LB IP Address record. https://<instance>.service-now.com/nav_to.do?uri=sys_rte_eb_script_operation.do?sys_id=f42d8859c387021050d22ecf6d40dd1e 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". Here is the flow of data into this field for Cloud Public IP Address class : 1. The data for a CI is loaded into staging table : sn_sg_azure_integ_public_ip_address, 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 operationalStatus for a Cloud Public IP Address record from staging table record. https://<instance>.service-now.com/nav_to.do?uri=sys_rte_eb_field.do?sys_id=a02d8859c387021050d22ecf6d40dd1b 3. The value of operationalStatus attribute from staging table is mapped to operational_status field in Public IP address table. If there is an issue reported for populating Operational Status field, review the nested JSON payload in data field of "sn_sg_azure_integ_public_ip_address" 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