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 SUP sync error The underlying connection was closed  Could not establish trust relationship for the SSL/TLS secure channel

  I was contacted by colleague that Configmgr is not showing the updates that were published day ago by SCUP . So i started checking the SCUP configuration (proxy) and the updates status if they are published or not using the date published and also verified SCUP logs. From SCUP perspective,all looks good. Next to…
SCCM Configmgr How to make SCUP console settings available for all users and make the database as shared

If you are using SCUP (system Center Update Publisher) tool to manage 3rd Party updates integrated with Configuration manager, there are 2 things which you need to look at . 1) The settings that are configured in SCUP Console are per user specific and stored in User profile (user.config in C:\Users\%UserName%\AppData\Local\Microsoft\Scup2011.exe_StrongName_XXXXXXXXXX) 2) Database file that…
SCCM Configmgr Failed to initiate install of WSUS updates, error = 0x80246002

While i was checking the software update compliance reports for Microsoft and Non-Microsoft (3rd party updates ,SCUP integrated) ,i see that ,compliance report looks good for Microsoft but not for 3rd party updates. SCCM Version: Configmgr Current Branch 1702 with SCUP integrated for 3rd party updates. During the investigation on 1 client, found that ,it…
SCCM Configmgr powershell to enable the option software update deployment re-evaluation behaviour upon restart

  With Configuration manager 1606 ,new feature was added to software updates section which is called ‘Run software updates compliance scan immediately after a client installs software updates and restarts’ . This feature really helps to run a software update compliance scan immediately after a client installs software updates and restarts.This feature enables the client…