Configmgr How use compliance settings to check windows update agent version (WUA) is older ,Collection and SQL query

Using compliance settings in Configmgr, you can do many tasks as part of compliance. In the last couple of blogs, we have utilized compliance settings to identify WU settings,automatic update,trusted publisher settings etc. http://eskonr.com/2017/10/configmgr-how-to-use-compliance-settings-to-check-the-windows-update-policy-settings-like-wuserver-usewuservernoautoupdate-on-clients/ In this blog post ,we will see how to use compliance settings to check for Windows update agent version if it…
Configmgr SQL query to get the list of clients that require a specific software update patch

This is quick blog post about getting the list of clients that require a specific software update contained (it can be based on title,article ID(KB),bulletin ID). You can get the client list using the default software update compliance reports but it doesn't give you the inventory information about client ,like ip address,hardware scan,software update scan…
SCCM Configmgr Report for Boundary group relationships with Fallback Sites

Beginning with Configmgr Version 1702, clients use boundary groups to find a new software update point. You can add individual software update points to different boundary groups to control which servers a client can find. More information about boundary groups and its relation with  software update point changes in 1702 and 1706 ,please refer TechNet…
SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…
SCCM Configmgr Unable to run SSRS reports due to HTTP 500 Internal Server Error

Setting up Configuration Manager current branch (1702) lab for testing. While running the Configmgr reports using IE browser ,http://servername/Reports/Pages/Folder.aspx ,it failed with error code HTTP 500 Internal Server Error. SQL server installed locally on Configmgr box . I have seen this error couple of time but i don't remember what was the solution to get…