ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM | Configuration Manager

Let’s check the details of ConfigMgr CMPivot Query to Find Clients not Part of any Boundary Groups. This CMPivot query is published in Community Hub and all the credits are to Microsoft PFE Zvensch. With this query, you can find clients that are not part of any boundaries.

The clients won’t be able to get any of the policies when the clients are not part of any boundary groups. So, this CMPivot query helps to identify problematic clients and fix the boundary issues. I would recommend reading more about the process of creating boundary groups.

You can use Community Hub on Windows Server Operating System with the ConfigMgr Current Branch 2010 or later. That means you can access the community hub from the primary server or any other server with an SCCM admin console. You can check the prerequisites of Community Hub from Microsoft Docs.

How to Access Community Hub & Download

Let’s check how to access the community hub from ConfigMgr’s primary server console.

Patch My PC
  • Navigate \Community\Community hub.
  • Select the CMPivot query called Client without Boundary.
  • Click on the Download button.
ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM
ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM
  • Click on the Your Downloads tab.

NOTE! – I’m not able to find the location where the CMPivot query is stored. Let me know in the comments section if you know the location.

ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM
ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM

CMPivot Query

You can get the CMPivot query to find the list of “Clients not Part of Any Boundary Groups” in your ConfigMgr environment. You can check the GitHub repository to check the details of this CMPivot query.

NOTE! – CMPivot query can give you the results of the ONLINE devices available at the time of execution of the query.

CcmLog('LocationServices') | where LogText contains 'Client is not in any boundary group.' | project Device, LogText, DateTime
ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM
ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM

Resources

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

Adaptiva

2 thoughts on “ConfigMgr CMPivot Query to Find Clients not Part of Any Boundary Groups | SCCM | Configuration Manager”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.