Task 2: Create the flat table in the SQL server database

A database administrator must create a new table in the SQL Server SCCM database that uses the column names from SCCM listed here.

The table can have any name (for example, SCCM_Computer_Staging). This is a flat table that gathers specific data directly from SCCM tables and makes it accessible to the ServiceNow instance through the use of an intermediate map provided in the baseline system. The SCCM columns are mapped to custom fields in this intermediate map that have been truncated to fit in the ServiceNow database schema. To view the intermediate map, navigate to Integration - Microsoft SCCM > Web Services > Computer Info. Fields in this list are mapped to existing fields in the CMDB by Transform Maps used by the SCCM Computer Info Data Source.

After creating the flat table, a database administrator must create a schedule in the SQL database for a periodic data import between the SCCM tables (such as hardware, disk and network adapter table) and the flat table. Then the SCCM import schedule can run right after the creation or update of the flat table and import the data into the SCCM Computer Info [imp_sccm_computer_info] table.

Table Columns

The flat table to be imported to the SCCM Computer Info [imp_sccm_computer_info] table must contain the following columns:
Table 1. Table Columns
Column 1 Column 2 Column 3 Column 4
v_GS_Computer_System_model0 v_GS_Disk_manufacturer0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_0 v_GS_PC_BIOS_Name0
v_GS_Computer_System_name0 v_GS_Disk_manufacturer0_1 v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_1 v_GS_PC_BIOS_Resourceid
v_GS_Computer_System_status0 v_GS_Disk_mediatype0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_2 v_GS_PC_BIOS_Serialnumber0
v_GS_Computer_System_numberofprocessors0 v_GS_Disk_mediatype0_1 v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_0 v_GS_Processor_manufacturer0
v_GS_Computer_System_TimeStamp v_GS_Disk_name0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_1 v_GS_Processor_name0
v_GS_Computer_System_UserName0 v_GS_Disk_name0_1 v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_2 v_GS_Processor_resourceid
v_GS_Computer_System_resourceid v_GS_Disk_resourceid_0 v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 v_GS_Processor_maxclockspeed0
v_GS_Computer_System_manufacturer0 v_GS_Disk_resourceid_1 v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_1 v_GS_System_Domain
v_GS_Disk_deviceid0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_2 v_GS_System_name
v_GS_Disk_deviceid0_1 v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_1 v_GS_Operating_System_totalvisiblememorysize0 v_GS_System_resourceid
v_GS_Disk_deviceid_0 v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_2 v_GS_Operating_System_csdversion0 v_GS_System_systemrole0
v_GS_Disk_deviceid_1 v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_0 v_GS_Operating_System_resourceid v_GS_System_systemtype
v_GS_Disk_Interfacetype0_0 v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_1 v_GS_Operating_System_caption0 v_GS_WORKSTATION_STATUS_lasthwscan
v_GS_Disk_Interfacetype0_1 v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_2 v_GS_Operating_System_version0 v_GS_WORKSTATION_STATUS_resourceid

SQL Script Sample

Warning: This script is an example of an SQL Server script that creates a flat table for SCCM data and is not intended to be run as is. Use this script as a template only and modify it for your environment.
CREATE TABLE [dbo ] . [SCCM_Computer_Staging ] ( [v_GS_Computer_System_resourceid ] [ INT ] NOT NULL , [v_GS_Computer_System_UserName0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Computer_System_manufacturer0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Computer_System_numberofprocessors0 ] [ INT ] NULL , [v_GS_Computer_System_model0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Computer_System_status0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Computer_System_TimeStamp ] [datetime ] NULL , [v_GS_Disk_resourceid_0 ] [ INT ] NULL , [v_GS_Disk_manufacturer0_0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_deviceid0_0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Disk_mediatype0_0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_Interfacetype0_0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_deviceid_0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_name0_0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Disk_resourceid_1 ] [ INT ] NULL , [v_GS_Disk_manufacturer0_1 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_deviceid0_1 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Disk_mediatype0_1 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_Interfacetype0_1 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Disk_deviceid_1 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Disk_name0_1 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_0 ] [ INT ] , [v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_0 ] [ INT ] NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_0 ] [ VARCHAR ] ( 255 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_1 ] [ INT ] NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_1 ] [ INT ] NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_1 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_1 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_1 ] [ VARCHAR ] ( 152 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_2 ] [ INT ] NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_2 ] [ INT ] NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_2 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_2 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_2 ] [ VARCHAR ] ( 255 ) NULL , [v_GS_Operating_System_resourceid ] [ INT ] NULL , [v_GS_Operating_System_version0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Operating_System_csdversion0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Operating_System_totalvisiblememorysize0 ] [ INT ] NULL , [v_GS_Operating_System_caption0 ] [ VARCHAR ] ( 128 ) NULL , [v_GS_PC_BIOS_Resourceid ] [ INT ] NULL , [v_GS_PC_BIOS_Name0 ] [ VARCHAR ] ( 72 ) NULL , [v_GS_PC_BIOS_Serialnumber0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Processor_resourceid ] [ INT ] NULL , [v_GS_Processor_manufacturer0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_Processor_name0 ] [ VARCHAR ] ( 64 ) NULL , [v_GS_Processor_maxclockspeed0 ] [ INT ] NULL , [v_GS_System_resourceid ] [ INT ] NULL , [v_GS_System_systemrole0 ] [ VARCHAR ] ( 50 ) NULL , [v_GS_System_name ] [ VARCHAR ] ( 64 ) NULL , [v_GS_System_Domain ] [ VARCHAR ] ( 50 ) NULL , [v_GS_System_systemtype ] [ VARCHAR ] ( 50 ) NULL , [v_GS_WORKSTATION_STATUS_resourceid ] [ INT ] NULL , [v_GS_WORKSTATION_STATUS_lasthwscan ] [datetime ] NULL , [v_GS_Computer_System_name0 ] [ VARCHAR ] ( 64 ) NULL ) ON [ PRIMARY ]
 
 SELECT * FROM dbo .SCCM_Computer_Staging
 
 INSERT INTO SCCM_Computer_Staging 
 ( [v_GS_Computer_System_resourceid ] , [v_GS_Computer_System_UserName0 ] , [v_GS_Computer_System_manufacturer0 ] , [v_GS_Computer_System_numberofprocessors0 ] , [v_GS_Computer_System_model0 ] , [v_GS_Computer_System_status0 ] , [v_GS_Computer_System_TimeStamp ] , [v_GS_Computer_System_name0 ] )
 
 
 SELECT   resourceid , UserName0 , manufacturer0 , numberofprocessors0 , model0 , status0 , TIMESTAMP , Name0  
 FROM dbo .v_GS_COMPUTER_SYSTEM 
 WHERE ResourceID  IS NOT NULL
 
 
 SELECT DISTINCT (a .MACAddress0 ) ,a .ResourceID 
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .AdapterType0  IS NOT NULL AND a .AdapterType0 = 'Ethernet 802.3' AND a .MACAddress0 ! = '' AND a .AdapterType0  IS NOT NULL AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND b .ServiceName0! = 'FirehkMP' ORDER BY a .ResourceID
 
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET v_GS_Disk_resourceid_0  = a .resourceid ,
	v_GS_Disk_manufacturer0_0 = a .manufacturer0  ,
	v_GS_Disk_deviceid0_0  = a .DeviceID0 ,
	v_GS_Disk_mediatype0_0  = a .mediatype0 ,
	v_GS_Disk_Interfacetype0_0  = a .interfacetype0 ,
	v_GS_Disk_name0_0 = a .name0
 FROM [dbo ] . [v_GS_DISK ]a  , [dbo ] . [SCCM_Computer_Staging ]b
 WHERE a .resourceid  = b .v_GS_Computer_System_resourceid	  
 
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET v_GS_Disk_resourceid_1  = a .resourceid ,
	v_GS_Disk_manufacturer0_1 = a .manufacturer0  ,
	v_GS_Disk_deviceid0_1  = a .DeviceID0 ,
	v_GS_Disk_mediatype0_1  = a .mediatype0 ,
	v_GS_Disk_Interfacetype0_1  = a .interfacetype0 ,
	v_GS_Disk_name0_1 = a .name0
 FROM [dbo ] . [SCCM_Computer_Staging ] b , [dbo ] . [v_GS_DISK ] a
 WHERE b .v_GS_Computer_System_resourceid  = a .ResourceID  AND b .v_GS_Disk_deviceid0_0 ! = a .DeviceID0
 
 
 /****** Script for SelectTopNRows command from SSMS  ******/ SELECT DISTINCT a .MACAddress0 ,a .Description0 , a .ResourceID , a .AdapterType0
 /*, b.DHCPEnabled0, b.ServiceName0, b.IPAddress0 */ FROM [dbo ] . [v_GS_NETWORK_ADAPTER ]  a
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0  NOT LIKE ( 'McAfee NDIS Intermediate Filter Miniport' ) AND a .Description0
 NOT LIKE ( 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' ) AND a .Description0  NOT LIKE ( 'Packet Scheduler Miniport' ) AND a .Description0
 NOT LIKE ( 'VirtualBox Bridged Networking Driver Miniport' ) AND a .Description0
 NOT LIKE ( 'VirtualBox Host-Only Ethernet Adapter' ) ORDER BY ResourceID
 
 SELECT DISTINCT a .MACAddress0 ,a .Description0 , a .ResourceID , a .AdapterType0   ,b .DHCPEnabled0 , b .ServiceName0 , b .IPAddress0 
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a  , [dbo ] . [v_GS_NETWORK_ADAPTER_CONFIGUR ] b
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0
 NOT IN ( 'McAfee NDIS Intermediate Filter Miniport' , 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' , 'VirtualBox Host-Only Ethernet Adapter' , 'Packet Scheduler Miniport' , 'VirtualBox Bridged Networking Driver Miniport' , 'Bluetooth Device (Personal Area Network)' ) AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND b .ServiceName0! = 'FirehkMP' ORDER BY a .ResourceID
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_0 ] = b .ResourceID  , [v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_0 ] = b .DHCPEnabled0  , [v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_0 ] = b .ServiceName0  , [v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 ] = b .MACAddress0 , [v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_0 ] = b .IPAddress0
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a  , [dbo ] . [v_GS_NETWORK_ADAPTER_CONFIGUR ] b , [dbo ] . [SCCM_Computer_Staging ] c 
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0  NOT IN ( 'McAfee NDIS Intermediate Filter Miniport' , 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' , 'VirtualBox Host-Only Ethernet Adapter' , 'Packet Scheduler Miniport' , 'VirtualBox Bridged Networking Driver Miniport' , 'Bluetooth Device (Personal Area Network)' ) AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND b .ServiceName0! = 'FirehkMP' AND c .v_GS_Computer_System_resourceid  = b .ResourceID
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_1 ] = b .ResourceID  , [v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_1 ] = b .DHCPEnabled0  , [v_GS_NETWORK_ADAPTER_CONFIGUR_servicename0_1 ] = b .ServiceName0  , [v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_1 ] = b .MACAddress0 , [v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_1 ] = b .IPAddress0
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a  , [dbo ] . [v_GS_NETWORK_ADAPTER_CONFIGUR ] b , [dbo ] . [SCCM_Computer_Staging ] c
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0  NOT IN ( 'McAfee NDIS Intermediate Filter Miniport' , 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' , 'VirtualBox Host-Only Ethernet Adapter' , 'Packet Scheduler Miniport' , 'VirtualBox Bridged Networking Driver Miniport' , 'Bluetooth Device 
(Personal Area Network)' ) AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND b .ServiceName0! = 'FirehkMP' AND c .v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 ! = b .MACAddress0 
 AND c .v_GS_Computer_System_resourceid  = b .ResourceID
 
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET v_GS_Disk_resourceid_0  = a .resourceid ,
	v_GS_Disk_manufacturer0_0 = a .manufacturer0  ,
	v_GS_Disk_deviceid0_0  = a .DeviceID0 ,
	v_GS_Disk_mediatype0_0  = a .mediatype0 ,
	v_GS_Disk_Interfacetype0_0  = a .interfacetype0 ,
	v_GS_Disk_name0_0 = a .name0
 FROM [dbo ] . [v_GS_DISK ]a  , [dbo ] . [SCCM_Computer_Staging ]b
 WHERE a .resourceid  = b .v_GS_Computer_System_resourceid
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET v_GS_Disk_resourceid_1  = a .resourceid ,
	v_GS_Disk_manufacturer0_1 = a .manufacturer0  ,
	v_GS_Disk_deviceid0_1  = a .DeviceID0 ,
	v_GS_Disk_mediatype0_1  = a .mediatype0 ,
	v_GS_Disk_Interfacetype0_1  = a .interfacetype0 ,
	v_GS_Disk_name0_1 = a .name0
 FROM [dbo ] . [SCCM_Computer_Staging ] b , [dbo ] . [v_GS_DISK ] a 
 WHERE b .v_GS_Computer_System_resourceid  = a .ResourceID  AND b .v_GS_Disk_deviceid0_0 ! = a .DeviceID0
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_Operating_System_resourceid ] = a .ResourceID , [v_GS_Operating_System_version0 ] = a .version0 , [v_GS_Operating_System_csdversion0 ] = a .csdversion0 , [v_GS_Operating_System_totalvisiblememorysize0 ] = a .totalvisiblememorysize0 , [v_GS_Operating_System_caption0 ] = a .caption0
 FROM [dbo ] .v_GS_OPERATING_SYSTEM a  , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .ResourceId  = b .v_GS_Computer_System_resourceid
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_PC_BIOS_Resourceid ] = a .ResourceID , [v_GS_PC_BIOS_Name0 ] = a .Name0 , [v_GS_PC_BIOS_Serialnumber0 ] = a .SerialNumber0
 FROM [dbo ] .v_GS_PC_BIOS a  , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .ResourceId  = b .v_GS_Computer_System_resourceid
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_Processor_resourceid ] = a .ResourceID , [v_GS_Processor_manufacturer0 ] = a .Manufacturer0 , [v_GS_Processor_name0 ] = a .Name0 , [v_GS_Processor_maxclockspeed0 ] = a .MaxClockSpeed0
 FROM [dbo ] .v_GS_Processor a  , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .ResourceId  = b .v_GS_Computer_System_resourceid
 
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_System_resourceid ] = a .ResourceID  , [v_GS_System_systemrole0 ] = a .SystemRole0  , [v_GS_System_name ] = a .Name0 , [v_GS_System_Domain ] = a .Domain0 , [v_GS_System_systemtype ] = a .SystemType0
 FROM [dbo ] .v_GS_System a  , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .ResourceId  = b .v_GS_Computer_System_resourceid
 
 UPDATE [dbo ] . [SCCM_Computer_Staging ] SET [v_GS_WORKSTATION_STATUS_resourceid ] = a .ResourceID , [v_GS_WORKSTATION_STATUS_lasthwscan ] =a .LastHWScan
 FROM [dbo ] .v_GS_WORKSTATION_STATUS a  , [dbo ] . [SCCM_Computer_Staging ] b
 WHERE a .ResourceId  = b .v_GS_Computer_System_resourceid
 
 SELECT * FROM [dbo ] . [SCCM_Computer_Staging ]
 
 
 SELECT b .resourceId  
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a  , [dbo ] . [v_GS_NETWORK_ADAPTER_CONFIGUR ] b , [dbo ] . [SCCM_Computer_Staging ] c 
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0  NOT IN ( 'McAfee NDIS Intermediate Filter Miniport' , 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' , 'VirtualBox Host-Only Ethernet Adapter' , 'Packet Scheduler Miniport' , 'VirtualBox Bridged Networking Driver Miniport' , 'Bluetooth Device 
(Personal Area Network)' ) AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND 
b .ServiceName0! = 'FirehkMP' AND c .v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 ! = b .MACAddress0  AND 
c .v_GS_Computer_System_resourceid  = b .ResourceID
 ORDER BY b .ResourceID
 
 
 SELECT b .resourceId ,b .DHCPEnabled0 ,b .IPAddress0 ,b .ServiceName0   
 FROM [dbo ] . [v_GS_NETWORK_ADAPTER ] a  , [dbo ] . [v_GS_NETWORK_ADAPTER_CONFIGUR ] b 
 WHERE a .MACAddress0  IS NOT NULL AND a .MACAddress0 ! = '00:00:00:00:00:00' AND a .AdapterType0 = 'Ethernet 802.3' AND a .Description0  NOT IN ( 'McAfee NDIS Intermediate Filter Miniport' , 'Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64' , 'VirtualBox Host-Only Ethernet Adapter' , 'Packet Scheduler Miniport' , 'VirtualBox Bridged Networking Driver Miniport' , 'Bluetooth Device 
(Personal Area Network)' ) AND a .resourceId = b .ResourceID  AND a .MACAddress0  = b .MACAddress0  AND b .ServiceName0  IS NOT NULL AND 
b .ServiceName0! = 'FirehkMP'
 
 
 SELECT a .v_GS_NETWORK_ADAPTER_CONFIGUR_resourceid_0 , 
a .v_GS_NETWORK_ADAPTER_CONFIGUR_Ipaddress0_0 , 
a .v_GS_NETWORK_ADAPTER_CONFIGUR_macaddress0_0 , 
a .v_GS_NETWORK_ADAPTER_CONFIGUR_dhcpenabled0_0
 FROM [dbo ] . [SCCM_Computer_Staging ] a