Now the PXE process will find the correct PC and you’re good to go. Go to your OS deployment collection and check out the Resource ID there.ĭelete the PC with the Resource ID NOT present in your OS deployment collection. The PC might be present more than once, with the same PC-name and MAC addressĬheck this out by searching for the PC in Devices (add the column field “ Resource ID”) If a computer, although present in SCCM with correct MAC address and present in a OS Deployment collection, is refusing to PXE boot (or reports there is nothing to install) try checking the following: 1. Where v_FullCollectionMembership.CollectionID = by v_R_System_Valid.No PXE boot or reports there is nothing to install.Ĭomputer will not PXE boot – or reports there is nothing to install. Left join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP on (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_LOGICAL_DISK on (v_GS_LOGICAL_DISK.ResourceID = v_R_System_Valid.ResourceID) and v_GS_LOGICAL_DISK.DeviceID0=SUBSTRING(v_GS_OPERATING_SYSTEM.WindowsDirectory0,1,2) Left join v_Site on (v_FullCollectionMembership.SiteCode = v_Site.SiteCode) Inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_PROCESSOR on (v_GS_PROCESSOR.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_X86_PC_MEMORY on (v_GS_X86_PC_MEMORY.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) Left join v_GS_SYSTEM_ENCLOSURE_UNIQUE on (v_GS_SYSTEM_ENCLOSURE_UNIQUE.ResourceID = v_R_System_Valid.ResourceID) Inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) Where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and v_FullCollectionMembership.CollectionID = As (Select sum(v_GS_LOGICAL_DISK.FreeSpace0) V_FullCollectionMembership.CollectionID = As , Where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and V_GS_PROCESSOR.NormSpeed0 AS ,įrom v_GS_LOGICAL_DISK inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_GS_LOGICAL_DISK.ResourceID ) V_GS_X86_PC_MEMORY.TotalPhysicalMemory0 AS , V_GS_SYSTEM_ENCLOSURE_UNIQUE.SMBIOSAssetTag0 AS , V_GS_SYSTEM_ENCLOSURE_UNIQUE.SerialNumber0 AS , Then v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0

When (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 = '-1') V_R_System_Valid.Resource_Domain_OR_Workgr0 AS , I wanted to use Hardware 01A report to include the MAC Adresses but I don't know how to do it.

Clear mac address from sccm