How to: Create a machine based smart label based on IP Subnet?
Hi,
We're trying to use the K1000 for managed install using their local replica server, however some our sites are split up via DHCP so for example:
10.61.41.0 to 10.61.41.30 is a different site / smart label than:
10.61.41.31 to 10.61.41.38
I tried using IP address is '<' '>' to no avail.
Is there any solution for this?
We're trying to use the K1000 for managed install using their local replica server, however some our sites are split up via DHCP so for example:
10.61.41.0 to 10.61.41.30 is a different site / smart label than:
10.61.41.31 to 10.61.41.38
I tried using IP address is '<' '>' to no avail.
Is there any solution for this?
0 Comments
[ + ] Show comments
Answers (7)
Please log in to answer
Posted by:
omallem
9 years ago
I'm not sure exactly which release the change was made, but you can now use the > and < to define the IP address sequence. I tested with 6.3.
Posted by:
airwolf
13 years ago
You would need to do a "matches regex" and use regular expressions like 10\.61\.41\.[0-3][0-9]? and 10\.61\.41\.3[1-8].
Posted by:
craig.thatcher
13 years ago
or you could use the built in mysql function
inet_aton like so....
select *
from MACHINE
WHERE INET_ATON(IP) BETWEEN INET_ATON('162.114.75.1') AND INET_ATON('162.114.75.255')
INET_ATON FUNCTION
inet_aton like so....
select *
from MACHINE
WHERE INET_ATON(IP) BETWEEN INET_ATON('162.114.75.1') AND INET_ATON('162.114.75.255')
INET_ATON FUNCTION
Posted by:
AndrewPa
13 years ago
ORIGINAL: airwolf
You would need to do a "matches regex" and use regular expressions like 10\.61\.41\.[0-3][0-9]? and 10\.61\.41\.3[1-8].
Love your work...
but one last thing: in testing I noticed that expression also had items 10.61.41.145 come up... :(
Anyway to limit the last quadrant to just 2 numbers for instance?
Posted by:
scottlutz
13 years ago
If you want to stick with a RegEx, give the following URL a look. Just enter the start and end IP addresses, and it spits out the RegEx:
http://www.analyticsmarket.com/freetools/ipregex
http://www.analyticsmarket.com/freetools/ipregex
Posted by:
AndrewPa
13 years ago
ORIGINAL: scottlutz
If you want to stick with a RegEx, give the following URL a look. Just enter the start and end IP addresses, and it spits out the RegEx:
http://www.analyticsmarket.com/freetools/ipregex
Amazing!! Works perfect. Thank you :)
Posted by:
GillySpy
13 years ago
In addition to whatever expression you are using make sure you know which IP address of the machine you are interested in. Based on your question I'm guessing that you are only interested in the IP of the NIC that the machine is currently using to connect to kbox with. See this post: http://www.appdeploy.com/messageboards/fb.asp?m=63482
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.