Forbes suggests a workaround to the problem, which is also documented on the Windows forum thread.
Now, some of you are nodding your heads with a smile and others are probably banging their head in frustration while reminiscing on all of the hours they’ve spent on reporting.I know I’ve spent hours creating unique reports for my organization and trying to make them look pretty and easy to consume. I’ll be honest when Power BI came out I didn’t think anything of it. Operating_System_Name_and0 like '%server%' This query is set to look for the following criteria, and this information can be changed.Most recently his focus has been in SQL Reporting for SCCM, creation of Power Shell scripts to automate tasks and Power BI.It’s April 2017 and Microsoft has just released their fourth update / “version” of Windows 10 – externally referred to as the “Creators Update”.Since starting he’s worked with Active Directory, Group Policy, SCCM, SCOM and Power Shell.
Jordan currently works in the healthcare industry as an SCCM Infrastructure Team lead supporting over 150,000 endpoints.
However, once you figure out how it works together, it is capable of creating very pretty dynamic reports that managers can consume and you can turn into actionable data when remediating non-compliant devices. Resource ID from v_R_System left join v_Update_Compliance Status on v_R_System. Resource ID left join V_Update Info on v_Update_Compliance Status. CI_ID left join v_RA_System_Resource Names on v_R_System. Resource ID left join v_Update Scan Status on v_R_System. Resource ID left join v_GS_WORKSTATION_STATUS on v_R_System. Resource ID left Join v_GS_OPERATING_SYSTEM on v_R_System. So you’ve run the SQL query didn’t have any performance issues, installed Power BI and now you’re ready to use the shiny template to look at your servers and their patch compliance.
To help you out so that you don’t have to spend hours trying to figure out how to report on patch compliance I’ve created a Power BI template you can download from the Tech Net Gallery: https://gallery.technet.microsoft.com/Patch-Compliance-Reporting-a08f0fb6 Here’s a screenshot of it in my lab environment: Now anytime I present a report to management, I always have to make sure I explain very carefully what the report means because data without context leads to sad times for everyone involved. Status = '2' THEN 'MISSING' WHEN v_Update_Compliance Status. Fantastic here is a quick video on how to implement.
But since the update is automated and forced, Windows tries to install it again after rebooting, causing a loop of reboots for some users.
Writer Adrian Kingsley-Hughes of CNET sister site ZDNet wrote about his travails trying to install the update on Sunday and getting stuck in a series of reboots.
Register for live webcasts or join our Ask Microsoft Anything (AMA) sessions for exclusive access to Microsoft engineers, product specialists, and community experts.