SQL query
Question
Need SQL queryto make device collection based on boundary . boundary created base on IP address range.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Need SQL queryto make device collection based on boundary . boundary created base on IP address range.
Answers ( 3 )
Thank you
Hi Aamir,
here is some more information available for your requirement
http://eskonr.com/2020/04/how-to-create-a-collection-based-on-boundary-group-for-client-assignment-and-content-troubleshooting/
Collection based on IP address Range (example 10.0.0.0 and 10.0.0.255)
select SMS_R_System.Name, SMS_R_System.IPAddresses from SMS_R_System where SMS_R_System.IPAddresses > “10.0.0.0” and SMS_R_System.IPAddresses < "10.0.0.255"
Collection Based on subnet
select SMS_R_System.Name, SMS_R_System.IPSubnets from SMS_R_System where SMS_R_System.IPSubnets = "10.0.0.0" or SMS_R_System.IPSubnets = "128.0.0.0"