Population of "cmdb_key_value" table key values of a CI into the CMDB target table.

[neeraj22671]

Hello Team,

Description: I am brining the Azure-cloud Servers data through Service graph connector integration into ServiceNow CMDB tables. I have installed the Service graph connector step in Dev instance and all Servers coming from Azure cloud as expected.

Problem: The discovery source "SG-Azure" brining data of 24 classes out of which for few classes like "Windows", "Linux", "Virtual Machines" and "Network" few fields of CI like "IT owner" and "Support group" not coming from cloud.

I can see these details of VM class servers are available in "cmdb_key_value" table.  

The data is coming in staging table : sn_sg_azure_integ_virtual_machine.do from cloud.

I have installed the "IntegrationHub ETL" plugin in Dev instance still cannot achieve the desired output.

Requirement :  We need to bring fields "IT owner and "support group" from "cmdb_key_value" table to ServiceNow CMDB target table.

First I am focusing for Virtual Machine class and Windows class. 

Looking forward for your quick response..

With thanks

Neeraj

With thanks

Neeraj

[Doci1 · Accepted solution]

Hi @neeraj22671 , we have something similar, just for Company. I see two options here:

1. BR before insert in [cmdb_ci] for CIs with source SG-Azure and mentioned classes -> query [cmdb_key_value] for correct IT owner and SG in your case

2. or you can leverage ETL for the specific source and "2. Prepare Source Data for Mapping" use "Script Operation" to fill the same as in BR