Failed to install Configmgr Client- The client version does not match the MP version The client will not be installed

I was recently troubleshooting the sccm client installation issue on a server that was configured as a distribution point. Installation of client The client installation setup and process is very simple and straight forward unless you hit issues like this. When I started looking at the client installation log( ccmsetup.log), I saw the below information…
SCCM SQL query to list all the content of distribution point group

There was a request from twitter friend who is trying to create SQL report to list the content of distribution point group with content status such as total targeted, installed, progress and errors. Distribution point groups is available in configuration manager for almost several years . This basically provide a logical grouping of distribution points…
SCCM remote control failed to do Handshake in Server. An existing connection was forcibly closed by the remote host Error 80072746

You can use Configuration Manager remote control to remotely administer, provide assistance, or view any client computer in the hierarchy. You can use the remote control to troubleshoot hardware and software configuration problems on client computers and to provide support. Configuration Manager supports the remote control of all workgroup computers and domain-joined computers that run…
Check Microsoft office activation status using SCCM Compliance Settings

I did detailed blog post on 'how to get  office 365 proplus activation status' with help of extended MOF file and inventory changes. With this method ,you will get the activation details such as user email address, shared computer activation etc. For more information, please refer http://eskonr.com/2018/10/how-to-get-office-365-proplus-activation-status-and-excluded-apps-etc-using-sccm-configmgr/ . This method requires extension of MOF files…
How to install volume licensed versions of Project 2016 and Visio 2016 on computer that has office 365 proplus (Click-to-Run)

I have worked on couple of office 365 proplus rollout projects. In all projects ,one of the critical task is to manage MSI based deployments for visio/project 2016 on computer that runs office 365 proplus (Click-to-Run). Click-to-Run is the technology used to install Office 365 proplus subscription based .Windows Installer technology (MSI) was used to…
How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

Configuration Manager site database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. Being SCCM Admin, you need to understand the different categories of the SQL views, what information is stored in each view, and how the SQL views can be joined to…
Clean up your WSUS database for better performance and SCCM software update compliance

Introduction: With the recent Current Branch updates starting from 1806 , Microsoft is making good improvement on Software updates maintenance but there is lot to come in the near future. Read the Software updates maintenance tasks available in SCCM https://docs.microsoft.com/en-us/sccm/sum/deploy-use/software-updates-maintenance Many SCCM Admins think that ,installing WSUS ,doing initial configuration and configuring SUP role is…