Hi,
I am trying to match a list of IPs and Applications to their security zomes. I thought I could cover half the problem (primary IPs only) if I transform all IPs into numbers, which I did. Sadly I do not know how to find a number (IP) between the subnet upper and lower limits.
<tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance !!
I am trying to match a list of IPs and Applications to their security zomes. I thought I could cover half the problem (primary IPs only) if I transform all IPs into numbers, which I did. Sadly I do not know how to find a number (IP) between the subnet upper and lower limits.
A | B | C | D | F | G | H | I | J | ||
1 | Application name | Primary IP Address | Primary IP into Number | Secondary IP | Security zone | IP Range start | IP Range end | Range start into number | Range end into number | |
2 | Application 1 | 10.100.1.15 | 10,100,001,015 | Internal-restricted | 10.100.1.0 | 10.100.1.63 | 10,100,001,000 | 10,100,001,063 | ||
3 | Application 2 | 10.100.1.73 | 10,100,001,073 | Internal-voip | 10.100.1.64 | 10.100.1.127 | 10,100,001,064 | 10,100,001,127 | ||
4 | Application 3 | 192.168.20.55 | 192,168,020,055 | DMZ | 192.168.20.0 | 192.168.20.255 | 192,168,020,000 | 192,168,020,255 | ||
5 | Application 4 | 83.1.25.10 | 83,001,025,010 | 83.1.25.97, 83.1.25.103, 83.1.25.209 | Internet-Zone 1 | 109.11.93.192 | 109.11.92.255 | 109,011,093,192 | 109,011,092,255 | |
6 | Application 5 | 109.11.93.195 | 109,011,093,195 | Internet-Zone 2 | 83.1.25.0 | 83.1.25.255 | 83,001,025,000 | 83,001,025,255 |
<tbody>
</tbody>
Desired table | ||
Application name | IP Address | Security zone |
Application 1 | 10.100.1.15 | Internal-restricted |
<tbody>
</tbody>
Thanks in advance !!