Service Graph Connector for Microsoft SCCM - Struggling to get IP address from import table to CMDB

[Joshua Wolfe]

Hey!

So we have the Service Graph Connector for Microsoft SCCM set up within our ServiceNow instance (via JDBC type using SQLServer format).  It currently runs twice a week and these are the data sources we currently have:

1. SG-SCCM Computer Identity
2. SG-SCCM Computer OU
3. SG-SCCM Disk
4. SG-SCCM Last Discovered Update
5. SG-SCCM Network
6. SG-SCCM Operating System
7. SG-SCCM Processor
8. SG-SCCM Removed Software
9. SG-SCCM Removed Software AI
10. SG-SCCM SAMP Usage
11. SG-SCCM Software
12. SG-SCCM Software AI
13. SG-SCCM Software Edition
14. SG-SCCM Software Last Used

Currently, SG-SCCM Computer Identity runs first and the remaining Data Sources kick off afterwards. My question in particular is with the SG-SCCM Network. To make sure my question isn't about I believe we have the correct SQL statement because we DO get the IP address. 

Here is the SQL Statement:

SELECT
dhcpenabled0 as dhcpenabled0,
macaddress0 as macaddress0,
servicename0 as servicename0,
ipaddress0 as ipaddress0,
ipsubnet0 as ipsubnet0,
defaultipgateway0 as defaultipgateway0,
TimeStamp as TimeStamp,
resourceid as resourceid,
WorkstationStatus_DATA.TimeKey as ComputerTimeKey
FROM v_GS_Network_Adapter_Configuration
LEFT JOIN WorkstationStatus_DATA ON WorkstationStatus_DATA.MachineID = v_GS_Network_Adapter_Configuration.ResourceID
where v_GS_Network_Adapter_Configuration.ipaddress0 is not null and v_GS_Network_Adapter_Configuration.macaddress0 is not null and
v_GS_Network_Adapter_Configuration.servicename0 NOT IN ('NdisWan')

However, after we get the IP Address, MacAddress, Subnet, etc. above, we are trying to use the Robust Transform map to have that connect each computer (or device) to it's specific IP address. I can see all of this information in the import table and I have it pointing at the cmdb_ci_network_adapter table,  but the import set continues to show a empty for the target table field.  I am needing to get this corrected before I begin trying to use IP ranges for location after that.

Any suggestions or help would be greatly appreciated

[cbester]

I have a similar problem, bringing in a field from SCCM on the Computer table. I can see it on the import, but it does not come through onto the computer record.