IP address not populated through Legacy SCCM (different to Service Graph SCCM)DescriptionWhen customers use SCCM to discover different Servers(Windows, Linux), Computer Systems, it uses Data Source - SCCM 2016 Computer Identity. When we take a look at the Query which is run on the SCCM server the select statement doesn't query the IP address.CauseIt is expected behavior not to import the IP address as the query doesn't include the IP address.ResolutionIf the requirement is to populate the IP Address in the CIs discovered using SCCM, 1. Update the SCCM query to include IP Address.2. Update the import set table to add a field that will populate the data for the IP address.3. Update the Transform map to data from the Import set table to the target table. In OOTB design this is the query in the Dta source - SCCM 2016 Computer Identity which needs to be updated SELECTv_GS_COMPUTER_SYSTEM.Name0 as name,v_GS_COMPUTER_SYSTEM.domain0 as domain,v_GS_COMPUTER_SYSTEM.Model0 as model,v_GS_COMPUTER_SYSTEM.Manufacturer0 as manufacturer,v_GS_COMPUTER_SYSTEM.ResourceID,v_GS_COMPUTER_SYSTEM.UserName0 as username,v_GS_COMPUTER_SYSTEM.NumberOfProcessors0 as numberofprocessors,v_GS_SYSTEM.SystemRole0 as SystemRole,v_GS_OPERATING_SYSTEM.Caption0 as caption,v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 as chassistype,v_GS_WORKSTATION_STATUS.LastHWScan,v_GS_PC_BIOS.SerialNumber0 as BIOSSerialNumber,v_GS_COMPUTER_SYSTEM_PRODUCT.IdentifyingNumber0 as SystemSerialNumber,v_GS_COMPUTER_SYSTEM_PRODUCT.UUID0 as UUIDSerialNumber,v_GS_SYSTEM_ENCLOSURE.SerialNumber0 as ChassisSerialNumber,v_GS_BASEBOARD.SerialNumber0 as BaseboardSerialNumber FROM v_GS_COMPUTER_SYSTEMLEFT JOIN v_GS_WORKSTATION_STATUS ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_WORKSTATION_STATUS.ResourceIDLEFT JOIN v_GS_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM.ResourceIDLEFT JOIN v_GS_PC_BIOS ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_PC_BIOS.ResourceIDLEFT JOIN v_GS_OPERATING_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_OPERATING_SYSTEM.ResourceIDLEFT JOIN v_GS_COMPUTER_SYSTEM_PRODUCT ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM_PRODUCT.ResourceIDLEFT JOIN v_GS_SYSTEM_ENCLOSURE ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_SYSTEM_ENCLOSURE.ResourceIDLEFT JOIN v_GS_BASEBOARD ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_BASEBOARD.ResourceID