Search for Macs on certain IP's
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?
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
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%"