The following SQL query can be used to query the list of collections that doesn't have any deployments. you can review the number of collections with no deployments and you can further extend the query to exclude certain folders where you use these exception collections for troubleshooting or other purpose. select Col.Name, col.CollectionID, case when…
Configuration Manager report for a list of clients missing boundaries

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…
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 Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

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 report for local admins and local group members

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 list of deployments set to ignore maintenance window and Reboot Outside maintenance window

Introduction: Few months ago ,we had an issue with one of the deployment (it was software updates) that was deployed to collection with override service window due to emergency patch to be installed on the clients. Deployment went fine and results were positive .All good ,but after few days ,some clients were added to the…
SCCM Configmgr 2012 SSRS Report Clients assigned to what Management points

Brief information about proxy MP before we jump into the subject. Proxy Management Point(On Secondary Site) used mainly to avoid the excessive bandwidth usage over Slow Network links between clients located in the boundaries of a secondary site By Default,Proxy management Point and Distribution Point role will be enabled and installed with secondary site. More…