SQL Queries – All about Microsoft Endpoint Manager

Use SCCM to find the excluded apps in Microsoft 365 Apps or Office 365 Proplus for custom reporting

Posted on November 18, 2020 by Eswar Koneti | 0 Comments

I was asked by a customer to find the devices with excluded apps in C2R products such as Office 365 Proplus or Microsoft 365 Apps or Office 2019 etc. When…

Create a collection and upgrade the Configuration Manager Console

Posted on October 20, 2020 by Eswar Koneti | 2 Comments

I was recently assisting a customer on the Configuration Manager upgrade and after the upgrade is done, we need to upgrade the console on endpoint devices to the latest version.…

What is new in Configuration Manager 2006 for custom reports

Posted on September 20, 2020 by Eswar Koneti | 0 Comments

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…

How to prepare SCCM CMG Client installation switches for internet based client

Posted on May 24, 2020 by Eswar Koneti | 4 Comments

I was recently assisting a customer on the implementation of CMG to manage the windows devices over the internet. Due to COVID-19, majority of the workforce is working from home…

Configuration Manager report for a list of clients missing boundaries

Posted on May 8, 2020 by Eswar Koneti | 3 Comments

I did a few blog posts on the client's boundary and boundary groups for configuration manager build versions lower than 2002. In one of the blog posts, I talked about,…

What is new in Configuration Manager 2002 reporting

Posted on May 6, 2020 by Eswar Koneti | 0 Comments

Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2002 (MEMCM) via the opt-in method (fast-ring) which will is now available for you to install and also baseline version however the baseline media is…

SCCM SQL query to list all the content of distribution point group

Posted on April 15, 2020 by Eswar Koneti | 4 Comments

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,…

How to find ConfigMgr client boundary and boundary group details based on boundary group caching

Posted on December 25, 2019 by Eswar Koneti | 2 Comments

Use boundary groups in Configuration Manager to logically organize related network locations (boundaries) to make it easier to manage your infrastructure. You must Assign boundaries to boundary groups before using…