SCCM Right Click Tool Managed workloads of co-managed device

Co-management (cloud attach) enables you to manage Windows 10 or later devices simultaneously by using both Configuration Manager and Microsoft Intune. For more information about co-management, please refer here. For a device to be co-managed, one of the pre-requisite is Windows devices must be connected to Azure AD using Hybrid Azure AD joined or Azure…

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…
Investigating SCCM Client Policy Request and Communication Status with a Collection Specific Report

Introduction: As a SCCM Configmgr administrator, one of your key responsibilities is to ensure the health of SCCM clients for tasks like application deployment, software updates, and inventory management. Oftentimes, you may encounter situations where you need to identify computers that haven't contacted the server in a specific number of days or determine the clients…
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…
How to find ConfigMgr client boundary and boundary group details based on boundary group caching

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

  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 Report for Count of MS Office Versions updated with list of clients

Update: I have another post that shows the count of ms office version with architecture type 32 or 64 for specific collection on http://eskonr.com/2017/11/configmgr-report-for-count-of-ms-office-versions-with-architecture-type-32bit-and-64bit/ I wrote a blog post year ago on how to get count of MS Office Editions with versions installed across my environment using SCCM Configmgr. This report consists of 2 reports .1st…
SCCM Configmgr SQL Report get list of machines with one Version of application and exclude other versions

I had requirement from team to find out the clients that have one application (example Java) with one version installed and exclude clients that have multiple versions with same application installed. Lets take simple example . I have clients CLN01,CLN02,CLN03 and CLN04 and they have different versions of Java application installed on them. PC Name…