/build/static/layout/Breadcrumb_cap_w.png

[SOLVED] Machine smart labels using IP Address(es?)

Next question: I'm creating machine smart labels based on the "IP Address" field, using many different operators (contains, begins with, matches REGEX, and the not variant of each). I'm getting unexpected results, many more matches that I'd expect, based on the IP Address displayed in Inventory.

Which leads me to ask: what exactly does the "IP Address" field match on? When a computer has multiple NICs (e.g., a wireless one and an Ethernet one and a Bluetooth one), I see only one IP address in the Inventory, presumably the one in use when last connecting to the KBOX server.

But is the "IP Address" field matching on all the IP addresses ever used by this machine? Or maybe on the last IP address used on each NIC, which means matching on more than one IP address? This last scenario seems to be the way the queries are working, but I'm not sure.

If my question isn't clear, I can post an example. Sande

An

0 Comments   [ + ] Show comments

Answers (3)

Posted by: airwolf 11 years ago
Red Belt
0
I have several IP address labels setup to determine the location of my systems. The KBOX shows the IP address used by the client to connect to the KBOX as the primary IP address, but take a look at the inventory of a system with more than one network connection and you will see all of them listed under the Network Interfaces list. If you attempt a search where "IP Address" contains "192.168.1.", then it will trigger a match if ANY of the network connections match.
Posted by: GillySpy 11 years ago
7th Degree Black Belt
0
If you look at the query you will see that it is looking at all possible NICs for the machine.

If you want it to only hit machines whose active NIC (ie the NIC hitting the KBOX) matches an address then you need to modify the query.

For example, if you only want to send out a big install to machines on the local 192.168.1.* gigabit subnet:

select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as
LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as
LAST_SYNC_SECONDS
from ORG1.MACHINE
WHERE ( MACHINE.IP LIKE '192.168.1.%')
Posted by: snissen 11 years ago
Fourth Degree Green Belt
0
Oh, so that's what all that LEFT JOIN and 1 in (select...) stuff was for!

Thank you. That's exactly what I needed to know.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ