What do you have for a Sql query? what isn't working for ypu?
SCCM SQL Query to get Computers with boundary
Hi @AllenLiu-MSFT ,
Please provide SQL query to get Computes along with Boundary, Boundary Group name
2 additional answers
Sort by: Most helpful
-
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%'
-
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=configmanagerdeploymentLike 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.
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.