SCCM CMPivot Query to Find Clients Without Boundary

In this post we will use SCCM CMPivot query to find clients without boundary. When you run this query, you can find the clients that are not part of any boundary in SCCM.

The SCCM CMPivot query to find clients without boundary is actually published in SCCM community hub. All you need to do is connect to Community hub queries and download the query to find SCCM clients without boundary.

First of all, you must enable or turn on the community hub feature in Configuration Manager. It’s pretty easy and simple task. Go to Administration\Overview\Updates and Servicing\Features and right click Community Hub feature and click Turn on. If you encounter community hub loading issues, here is a post for you to fix SCCM community hub issues.

CMPivot is a new in-console utility that now provides access to real-time state of devices in your environment. It immediately runs a query on all currently connected devices in the target collection and returns the results.

We will run the SCCM CMPivot query on a device collection that consists of Windows 10 devices and find the clients without boundary. The devices have to be online in order to retrieve the installed service on them. In case the device is offline or not contactable, you would get to know about it in the query output.

So why is it important to find clients without boundary ?. SCCM boundaries are the locations on your network that contain the devices the you want to manage. Boundaries can be manually created or you can use the Active Directory forest discovery method to create them. So a client which is not a part of any boundary will essentially be a unmanaged client.

A client which is not a part of any boundary will not get SCCM client, application deployments etc. When you define a boundary, you intend to cover all your client machines. When you are using IP ranges to create boundary, sometimes you may miss some of the clients because of the IP range that you define. Hence it is important that you find clients without boundary in your setup and correct your boundary to include them.

SCCM CMPivot Query to Find Clients Without Boundary

Let’s look at the steps to find clients without boundary using SCCM CMPivot query. Launch the ConfigMgr console and go to Assets and Compliance > Overview > Device Collections. Right click the device collection and click Start CMPivot.

SCCM CMPivot Query to Find Clients Without Boundary
SCCM CMPivot Query to Find Clients Without Boundary

In the CMPivot tool, select the Query tab and in the right corner click Community Hub queries. Wait for few seconds while the tool connects to Community Hub and loads the CMPivot queries. From the list select Find Clients without boundary CMPivot query and double click the query.

The CMPivot query (find clients with no boundary group) now loads in the query editor. Use the below SCCM CMPivot query to find clients without boundary.

CcmLog('LocationServices') | where LogText contains 'Client is not in any boundary group.'
| project Device, LogText, DateTime

The above query looks for the line Client is not in any boundary in locationservices.log on client machines. If it finds that line in location services log file, it considers the client is not in boundary. However if you look at the below output, you can see all my 4 machines are in a boundary.

You may also change the log text contains to specific message such as Failed to retrieve Default Management Points from DNS or Failed to retrieve Default Management Points from lookup MP(s).

SCCM CMPivot Query to Find Clients Without Boundary
SCCM CMPivot Query to Find Clients Without Boundary

Click the Query Summary tab to find the status of the query. All my 4 machines are online and the query has been executed successfully on them. When you run this query in your production, you may find few clients that are not covered within the boundary.

SCCM CMPivot Query to Find Clients Without Boundary
SCCM CMPivot Query to Find Clients Without Boundary

Prajwal Desai

Hi, I am Prajwal Desai. For last few years I have been working on multiple technologies such as SCCM / Configuration Manager, Intune, Azure, Security etc. I created this site so that I can share valuable information with everyone.
Photo of author

Leave a Comment