{"id":804,"date":"2015-09-01T20:08:44","date_gmt":"2015-09-01T20:08:44","guid":{"rendered":"http:\/\/sccm.haas.se\/?p=804"},"modified":"2015-09-01T21:28:46","modified_gmt":"2015-09-01T21:28:46","slug":"quick-fix-for-scheduled-updates-and-windows-10","status":"publish","type":"post","link":"http:\/\/sccm.haas.se\/?p=804","title":{"rendered":"Quick-fix for Scheduled Updates and Windows 10"},"content":{"rendered":"<p>In System Center Configuration Manager 2012 Release 2, Service Pack 1, Cumulative Update 1. There is a bug. If you try to do offline servicing to a Windows 10 Operating System Image (also known as a Scheduled Update) there will be exactly zero visible software updates in the console to apply to the image. It&#8217;s annoying but it takes only 30 seconds to fix. But why does this happen? I&#8217;ll show you!<\/p>\n<p><a href=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/CMTrace1.jpg\"><img loading=\"lazy\" class=\"alignnone wp-image-806 \" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/CMTrace1-450x123.jpg\" alt=\"CMTrace\" width=\"501\" height=\"137\" srcset=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/CMTrace1-450x123.jpg 450w, http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/CMTrace1.jpg 850w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><\/p>\n<p>This is from\u00a0SMSProv.log at the same time I tried to Schedule an update and as\u00a0<!--more-->you can see, SCCM is looking for a version of Windows called &#8220;vNext Preview&#8221;. Which is what Windows 10 was called in the pre-release version. Howdy Mr. Bug. Now let&#8217;s fix it. Open SQL Management Studio and select\u00a0your ConfigMgr database. Then wander\u00a0down into tables&#8230;<\/p>\n<p><a href=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/sql0.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-818\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/sql0.jpg\" alt=\"sql0\" width=\"336\" height=\"236\" \/><\/a><\/p>\n<p>&#8230;until you find the table called &#8220;dbo.SupportedProductsForOfflineServicing&#8221;. If you want to you can select the top rows and have a look and it&#8217;ll look like the screenshot below.<\/p>\n<p><img loading=\"lazy\" class=\"\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/sql2-505x63-custom.jpg\" alt=\"sql2\" width=\"505\" height=\"63\" \/><\/p>\n<p>Right-click on the table &#8220;dbo.SupportedProductsForOfflineServicing&#8221; and choose Edit Top 200 Rows like so:<br \/>\n<a href=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/edit.jpg\"><br \/>\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-809\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/edit.jpg\" alt=\"edit\" width=\"336\" height=\"141\" \/><\/a><\/p>\n<p>Then change the value &#8220;Windows vNext Preview&#8221; to &#8220;Windows 10&#8221;. Without quotes of course. You don&#8217;t need to save anything, all changes you make in the database are live changes. Restart your ConfigMgr Console and voil\u00e0, all the patches are there! IF you have downloaded the patches first in the folder Software Updates in the console.<\/p>\n<p><a href=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/patches.jpg\"><img loading=\"lazy\" class=\"alignnone wp-image-810 size-medium\" src=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/patches-450x387.jpg\" alt=\"patches\" width=\"450\" height=\"387\" srcset=\"http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/patches-450x387.jpg 450w, http:\/\/sccm.haas.se\/wp-content\/uploads\/2015\/09\/patches.jpg 856w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>You can have a look in\u00a0OfflineServicingMgr.log in the CM-Log directory afterwards too see how the updates are applying.<\/p>\n<p>And OF COURSE this is not supported by Microsoft but I&#8217;ll be very surprised if their fix is not identical to this. Try it if you like but please don&#8217;t mess up your database and blame me afterwards, ok? Thanks and good luck!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In System Center Configuration Manager 2012 Release 2, Service Pack 1, Cumulative Update 1. There is a bug. If you try to do offline servicing to a Windows 10 Operating System Image (also known as a Scheduled Update) there will be exactly zero visible software updates in the console to apply to the image. It&#8217;s<\/p>\n<p class=\"text-right\"><span class=\"screen-reader-text\">Continue Reading&#8230; Quick-fix for Scheduled Updates and Windows 10<\/span><a class=\"btn btn-secondary continue-reading\" href=\"http:\/\/sccm.haas.se\/?p=804\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[32,34],"_links":{"self":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/804"}],"collection":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=804"}],"version-history":[{"count":14,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/804\/revisions"}],"predecessor-version":[{"id":827,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/804\/revisions\/827"}],"wp:attachment":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=804"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}