During the weekend, our SQL server ran a SP1 feature pack installation and all of a sudden on monday morning, my OSD failed on all computers, nothing been changed on  anything.

The client reboot straight after network connection... the restart itself.


<![LOG[There are no task sequences available to this computer.. Please ensure you have at least one task sequence advertised to this computer.


I have tried everywhere in the end I found this on WindowsNoob.



SO I ran a sql query against SCCM db

SELECT * FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)

and I got 2 rows. Which means no good, those two broken policies prevent the client to access other Task sequences assigned to it.

So another sql query to delete it:

Delete FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)

and restarted the MP the server went back.


Apparently I am the only one on that post only spend 4 hours, apparently people spend days even weeks, guess I am lucky?


About Lei

I am an IT specialist with over 10 year experience - years on Automation, on-Premise or Azure.

I am happy to develop however never want be a full time developer. Only do what I have to do. If it has to be PowerShell,HTML, PHP, CSS, C#, VBS or JS, front end or backend, so be it, doesn't matter!

Spent years with Windows, SCCM, SharePoint, SQL and Exchange servers. For last several years, I have been actively working under On Premise > Azure environment.


Current Certificates:
    Microsoft® Certified-
  • -Enterprise Administrator
  • -Database Administrator
  • -SharePoint Administrator
  • -Administering and Deploying SCCM 2012
Red Hat Certified Technician
ITIL V3 Foundation - Practitioner

Working on Azure Certificates now and hopefully they can stop upgrading their questions one day! GIVE ME A BREAK!

Contact Lei

Name *
Email *
Comments *

Traffic since 10/08/2016

This week13
This month2086

Visitor Info

  • IP:
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online