SQL query

Question

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

solved 0
Mohd Aamir 1 year 2020-05-19T23:33:02+05:30 3 Answers 149 views Beginner 0

Answers ( 3 )

    0
    2020-05-21T10:13:50+05:30

    Thank you

    1
    2020-05-20T03:39:01+05:30

    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 .