Category: SSRS Reports

What is new in Configuration Manager 2006 for custom reports

Posted on September 20, 2020 by | 0 Comments | 1,579 Views
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…
Read more »
Configuration Manager report for a list of clients missing boundaries

Posted on May 8, 2020 by | 3 Comments | 5,987 Views
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, how to identify the clients that are missing boundaries/boundary groups. For more information, please refer http://eskonr.com/2018/01/sccm-report-for-missing-boundaries-and-troubleshooting/ In all these blog posts, you would need to…
Read more »
SCCM SQL query to list all the content of distribution point group

Posted on April 15, 2020 by | 6 Comments | 9,299 Views
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…
Read more »
How to integrate Power BI Report Server with Configuration Manager reporting

Posted on January 23, 2020 by | 1 Comment | 4,813 Views
With the release of Microsoft Endpoint Manager configuration manager technical preview 2001 released in Jan 2020, we can now integrate Power BI Report Server with Configuration Manager reporting. Integrating configuration manager with Power BI Report Servers gives you modern visualization and better performance. It adds console support for Power BI reports similar to what already…
Read more »
How to find ConfigMgr client boundary and boundary group details based on boundary group caching

Posted on December 25, 2019 by | 7 Comments | 18,442 Views
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 the boundary group. Clients use a boundary group for: Automatic site assignment To find a site system server that can provide a service, including: Distribution…
Read more »
What is new in Configuration Manager 1910 reporting

Posted on December 4, 2019 by | 0 Comments | 2,162 Views
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…
Read more »
How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

Posted on July 23, 2019 by | 2 Comments | 8,645 Views
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…
Read more »