/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Search for Macs on certain IP's

04/01/2016 625 views
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


All 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

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