SCCM SQL Query to get Computers with boundary

Boopathi S 3,666 Reputation points
2021-11-02T20:38:11.497+00:00

Hi @AllenLiu-MSFT ,

Please provide SQL query to get Computes along with Boundary, Boundary Group name

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Garth 5,801 Reputation points
    2021-11-03T02:57:40.557+00:00

    What do you have for a Sql query? what isn't working for ypu?

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Rahul Jindal [MVP] 10,681 Reputation points MVP
    2021-11-02T22:49:46.8+00:00

    This is available directly in the console now. If you absolutely need to run a query, them try checking for name field against sys.views. I don't know the exact name nor I am sure if there is a view for this, but I would normally check by running a query like

    select name from sys.views where name like '%boundary%'

    0 comments No comments

  2. AllenLiu-MSFT 47,811 Reputation points Microsoft Vendor
    2021-11-03T02:31:53.377+00:00

    Hi, @Boopathi S
    Thank you for posting in Microsoft Q&A forum.

    There's no direct link between a client and boundaries in the database, check below link:
    https://social.technet.microsoft.com/Forums/ie/en-US/8ad1bec0-ff5c-4f4c-a480-be61a4188168/is-it-possible-to-create-collections-based-on-boundary-membership?forum=configmanagerdeployment

    Like RahulJindal-2267 said, we can get the info from console directly, the data updates when the client makes a location request to the site, or at most every 24 hours.
    146002-1.jpg

    For the details:
    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/boundary-group-procedures#show-boundary-groups-for-devices


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.