Hello,
I'm new to kace and I don't know if its me or Kace being a pain. I'm trying to pickup all the macs off of our different vlans here in the building. Please see the attached screenshot. Problem is, it keeps picking up windows operating systems as well even though I have it to only search for "begins with" Mac OS X. What am I doing wrong?
wFgS6d.jpeg
Thanks

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
Try putting the IP address requirements in a group and then have that combined with AND operating system name begins with Mac. Here's an example using the MySQL INET_ATON function:
SELECT MACHINE.ID, NAME, MACHINE.MAC, MACHINE.IP, LAST_INVENTORY, OS_NAME, CS_MODEL 
FROM ORG1.MACHINE
WHERE (INET_ATON(MACHINE.IP) between INET_ATON("172.16.96.1") and INET_ATON("172.16.103.255")
OR INET_ATON(MACHINE.IP) between INET_ATON("172.16.16.1") and INET_ATON("172.16.23.255"))
AND OS_NAME LIKE "Mac%"

Answered 04/04/2016 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share