How to Reset Group Policy Settings to Default. Next post SCCM WQL Query for MAC Address Prompt. WHERE (SYS.Client0 = 1) AND (NOT (NETW.DefaultIPGateway0 = 'NULL')) AND (NOT (IP.IP_Addresses0 = 'NULL')) AND (NOT (IP.IP_Addresses0 = '0.0.0.0')) and (NET.AdapterType0 = 'Ethernet 802. SCCM - Query for devices in a specific Active Directory Organisational Unit (OU) - If you are looking for a SCCM query query that will return all machines. INNER JOIN dbo.v_RA_System_SystemOUName ON IP.ResourceID = dbo.v_RA_System_SystemOUName.ResourceID INNER JOIN dbo.v_RA_System_IPAddresses IP ON IPSUB.ResourceID = IP.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER NET ON SYS.ResourceID = NET.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON SYS.ResourceID = NETW.ResourceID INNER JOIN dbo.v_GS_WORKSTATION_STATUS WS ON WS.ResourceID = SYS.ResourceID INNER JOIN dbo.v_R_System SYS ON IPSUB.ResourceID = SYS.ResourceID

TOP 100 PERCENT SYS.Name0, IP.IP_Addresses0, NET.MACAddress0,WS.LastHWScan,NET.Description0 Try something like this as your SQL Query:

How to find mac address in sccm 2012