Today, I will discuss 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 who are not part of any Boundary Groups.
This CMPivot query is published in Community Hub, and all the credits are for Microsoft PFE Zvensch. With this query, you can find clients who are not within any boundaries.
Clients not in boundary groups cannot access any of the policies. This CMPivot query helps identify problematic clients and fix boundary issues. I recommend reading more about creating boundary groups.
You can use Community Hub on the 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.
Table of Contents
How to Access Community Hub & Download
Let’s check how to access the community hub from ConfigMgr’s primary server console.
- Navigate \Community\Community hub.
- Select the CMPivot query called Client without Boundary.
- Click on the Download button.
- 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.
- Quickly Check Registry Values using SCCM CMPivot Query
- CMPivot Query to Find Windows 10 Devices
- How to Collect Intune Error Details using CMPivot
- How to Collect Windows Update Logs using CMPivot
- ConfigMgr CMPivot Favorite Query
- CMPivot Query to Fetch WSUS Server Details
CMPivot Query
You can get the CMPivot query to find the “Clients not Part of Any Boundary Groups” list 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 query execution.
CcmLog('LocationServices') | where LogText contains 'Client is not in any boundary group.' | project Device, LogText, DateTime
Resources
- Fix Missing SCCM Community Hub Issue| Enable | ConfigMgr
- SCCM CMPivot Browser Related Queries Default List of Browsers
- ConfigMgr Client App Vs SCCM Software Center
We are on WhatsApp now. To get the latest step-by-step guides, news, and updates, Join our Channel. Click here – HTMD WhatsApp
Author
Anoop C Nair has been Microsoft MVP for 10 consecutive years from 2015 onwards. He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is a Blogger, Speaker, and Local User Group Community leader. His primary focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career, etc.
I cannot find this or any other cmpviot downloads? Did you ever resolve this.
I can many other downloads are available. You can use CMPivot to get all the available downloads.