Did you miss to download your samples from Technet Gallery Here is how you can do it.

Technet Gallery has been there for almost 15 years for community to share scripts, files, utilities, tools etc for Microsoft Products. With the retirement/closure of Technet Gallery, there are large number of scripts/reports that I have uploaded to Technet for my blog and now am receiving the feedback from the blog readers that they cannot…
What is new in Configuration Manager 2006 for custom reports

Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2006 (MEMCM) via the opt-in method (fast-ring) on 8th of August, followed by slow-ring (GA) on 31st Aug. If you want to install a new Configuration Manager site (fresh build), you can download the baseline version which is 2003 from the volume licensing portal, and then do an…
Software Update Compliance report for CMG connected devices

With COVID-19 around the globe, the organizations who are using Configuration Manager have shown much interest in Cloud Management Gateway. Cloud Management Gateway helps you to manage the clients on the internet. For more information on how to setup CMG, please refer https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/cmg/setup-cloud-management-gateway A customer who recently deployed Cloud management gateway, wanted to monitor the…
What is new in Configuration Manager 1910 reporting

Microsoft has released update 1910 for SCCM which is now termed as Microsoft Endpoint Configuration Manager (#MEMCM) and is available as in-console update ONLY. You can apply this update on sites that runs on 1810 and later. For more information, please read If you want to install a new Configuration Manager site, you can download…
SCCM Configmgr How to get clients maintenance window with custom dates (Past and Future )

Introduction: Maintenance windows in Configmgr help to ensure that client configuration changes occur during periods that do not affect the productivity of the organization. Following Operations can be performed during the Maintenance window: Software update deployments Compliance settings deployment and evaluation Operating system deployments Task sequence deployments More about MW https://technet.microsoft.com/en-us/library/hh508762.aspx?f=255&MSPPError=-2147217396 Problem: So ,If you…
SCCM Configmgr SQL query to find Top X missing updates for specific collection for specific update group

Since few days ,I am working on a customized Software update compliance dashboard report with some Pie charts for management to see how the patch compliance progress for each Business Unit (I say business unit means for each country). Management are interested to see the overall patch compliance summary for each country (focused on servers…
SCCM Configmgr Get the Update Compliance Status for multiple Update groups against Multiple collections using SQL query without reporting

Recently ,we had an issue with SCCM Configmgr Reporting services role (Remote SQL sitting on VM was crashed ,blog post coming soon ) and we were unable to generate reports mainly for the Software update compliance status that happens every month. This post is about ,how to check the software update compliance status for the…
SCCM Configmgr Software update Compliance Report for multiple Software Update groups per collection

  Long ago ,did blog post on How to get software update compliance for specific update group per collection with drill down report to list the Required/missing ,unknown clients with some additional information like recent hardware inventory, last update scan results ,OS etc . This report will only work for single software update group per…