Create collections based on boundary group
With more and more AD admins being directed to "flatten" their sites and services, the ability to create query collections based on an AD site has become moot since boundaries are now having to be manually created by subnet or range. When a new subnet comes online or is taken off, not only does it have to be changed as a boundary and to subsequent groups but now any collections needing that range must also be updated. I'd rather one change to a group dynamically change all other collections tied to the group.
Richard Poole
shared this idea
8 comments
-
Bruno
commented
Hello
You can get all devices in a boundarygroup, using the wmi class SMS_CombinedDeviceResources
Try to build your collection with following queryselect SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
from SMS_R_System
left join SMS_CombinedDeviceResources on SMS_CombinedDeviceResources.ResourceId = SMS_R_System.ResourceId
where SMS_CombinedDeviceResources.boundarygroups='BGNAME'(replace BGNAME with actual boundarygroup name :) )
-
DaMehdi
commented
Hello,
i created this tool to resolv this problem, it'is free, enjoy guys -
Jose
commented
Any updates
-
DaleG
commented
I would also like to see a TS variable for boundary group as well
-
Mpho Msindo
commented
This will really help since we are looking at reducing our Secondary Sites. Part of the reason we are still installing Secondary Sites is that we can create collections based on the Site Code.
-
Harshal
commented
I think this is very good idea but it seems below collection queries work too.
-
Michael Schultz
commented
I am also looking for this. I would love ot be able to create collections based off both boundaries and boundary groups
-
Peter Laycock
commented
+1. Ran into this scenario today.
