At the Midwest Management Summit today in the 7 AM OSD Birds of a Feather session, there was a lot of discussion around troubleshooting PXE booting issues. A reference was made to a session that Troy Martin and I gave at the 2014 Midwest Management Summit called PXE Booting in the Real World. Troy put together some nice SQL queries that help with the troubleshooting process:
/* Get list of devices and their Last PXE boot for (a) required deployments */ SELECT * FROM [CM_PS1].[dbo].[LastPXEAdvertisement] order by MAC_Addresses /* Get item key for unknown records */ select * [CM_PS1].[dbo].[UnknownSystem_DISC] /* Is device known and a valid client on the site */ Use CM_PS1 exec NBS_LookupPXEDevice N'45A74041-2F02-4A5E-B413-CD35DDE47123',N'1E:1E:1E:1E:1E:B1' exec NBS_LookupPXEDevice N'2DCFD0F8-9134-44A3-84BB-0BFC114ADD87',N'1E:1E:1E:1E:1E:B2' /* Get list of deployments for device */ Use CM_PS1 exec NBS_GetPXEBootAction N'16777278',N'2046820352',N'45A74041-2F02-4A5E-B413-CD35DDE47123',N'1E:1E:1E:1E:1E:B1',N'CM12PS1.contoso.com' exec NBS_GetPXEBootAction N'16777279',N'2046820353',N'2DCFD0F8-9134-44A3-84BB-0BFC114ADD87',N'1E:1E:1E:1E:1E:B2',N'CM12PS1.contoso.com'
Here is a link to the slide deck that contains more information and a bunch of useful references.
Originally posted on https://miketerrill.net/