SQL query

Question

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

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

Answers ( 3 )

  2. Mohd Aamir
    0
    2020-05-21T10:13:50+05:30
    Reply

    Thank you

  4. Mohan Kumar
    1
    2020-05-20T04:41:51+05:30
    Reply
  6. Deepak Pathak
    1
    2020-05-20T03:39:01+05:30
    Reply

    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 permission to answer to this question .