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/
4 thoughts on “PXE Booting in the Real World”
your BIOS automation is amazing, I tried to download the task sequence from link below and seem like it has been removed. Is there anyways I can get it in my email or another link to download it.
You can also download an export of the Task Sequence (updated for CM 1511) here: Dell BIOS-UEFI Configuration for Windows 10 x64.zip
Thanks for your comment and bringing it to my attention. Try this link and I will get that updated in the other blog post.
I believe you forgot to add the link under “try this link”. and the original link is still broken.
Thanks for the help
I double checked the link in the blog post and it is working. It looks like it didn’t make it in the comment section though. So here is the full link if the one in the article still doesn’t work for you: https://onedrive.live.com/redir?resid=2563481D97B29297!85583&authkey=!AJM_d7Xo5mokoPM&ithint=file%2cpptx