SQL query – All about Microsoft Endpoint Manager

How to find custom hardware inventory classes imported (MOF) into ConfigMgr database

Posted on July 23, 2019 by Eswar Koneti | 2 Comments | 8,630 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…

Configmgr Report list empty collections with no query rules defined (collection clean-up)

Posted on January 13, 2018 by Eswar Koneti | 1 Comment | 5,196 Views

I was looking at the console other day and found that, there were many collections created in the root folder (device collection) with 0 count. So i looked at the collection properties ,i found empty there (No direct or query based rule). So i decided to write SQL query to identify the list of…

SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Posted on July 18, 2017 by Eswar Koneti | 6 Comments | 5,316 Views

Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…

SCCM Configmgr SQL WQL query compare 2 or more collections to get the difference

Posted on March 22, 2017 by Eswar Koneti | 1 Comment | 4,480 Views

This is quick post to show you ,how to compare 2 or more collections to find clients that are not member of other collections. The reason for me to write this collection is ,for server patching ,we have been using direct membership rules ( I know AD sec groups is good way to automate this…

SCCM ConfigMgr report for local admins and local group members

Posted on March 9, 2017 by Eswar Koneti | 104 Comments | 74,159 Views

I had a requirement to generate report to list members (users/groups) of local administrators group on servers for auditing purpose. Finding the users/groups who are member of local administrator group manually or scripting is tedious task on all servers .If you are managing the devices with configuration manager ,you can leverage Configmgr tool to get…

SCCM Configmgr How to get clients maintenance window with custom dates (Past and Future )

Posted on January 24, 2017 by Eswar Koneti | 6 Comments | 5,593 Views

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 how to find applications with no deployments as part of maintenance tasks

Posted on December 21, 2016 by Eswar Koneti | 10 Comments | 7,131 Views

Introduction: One of my blog reader asked question about ‘There is report in your blog to find out packages that has no advertisements created,but is there similar report to find applications with no deployments created’. I found this question is valid and is needed if you want to perform maintenance tasks like cleanup packages,applications,collections…

SCCM Configmgr 2012 SSRS Report Content Status with Compliance – Console View

Posted on November 23, 2015 by Eswar Koneti | 2 Comments | 1,448 Views

This post is an extension to my previous article to view the content status for the applications,packages,driver packages,software updates,windows images using SSRS report instead of Console. Few people contacted me ,if there is way to get the status /Report of all packages on all Distribution points with its compliance % and other information what is…