In the screenshot below, a client is attempting a network boot. Our second scenario will involve a known computer. Settings, such as computer name, can be specified before the task sequence actions begin. The client will continue the network boot. Line 5 shows that an optional advertisement was found. SCCM will see if any task sequence is deployed to the All Unknown Computers collection. You can see that process on line 2 in the screenshot above. These determine if the device is treated as an unknown (new) computer. SCCM will look up two identification items: the MAC and the SMBIOS GUID. We will see the following in our SMSPXE log: After we ensure that PXE is enabled on the NIC, we can attempt a network boot. Our first scenario involves a brand new computer, straight out of the box.
Open the SMSPXE.log file, and let’s explore the deployment process for an unknown computer for a bit. Reading the log is cumbersome without the Configuration Manager Trace Log tool ( which you can download from here). Check C:\Program Files\SMS_CCM\Logs on your site server if you can’t find it in the two locations above. The SMSPXE.log file can occasionally go missing (especially if you reconfigure your distribution point or change multicast settings). To troubleshoot unknown computer deployments, your first step is to locate this log file. This log location varies depending on the SCCM version, whether multicasting is enabled, and the setup of your environment. 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.When any device attempts a network boot off of a SCCM distribution point, that process is recorded in the SMSPXE log. 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: