SQL query

Question

Need SQL queryto make device collection based on boundary . boundary created base on IP address range.

solved 0
Mohd Aamir 5 months 3 Answers 120 views Beginner 0

Answers ( 3 )

  1. 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"

    Best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .