Creating a SMART Label to target machines that do not have a specific version of software installed
Fairly new to KACE and I've just noticed that some of my SMART Labels are not working as expected. Hope someone can help me out
I expected the SMART Label shown below to show all computers that have Adobe Flash Player installed AND the version is NOT 12.0.0.70 (Hope you can make that out from the dodgy screen shot)
It actually shows all computers that have Adobe Flash Player installed as long as they don't have any software title (not just Adobe Flash Player) that is version 12.0.0.70
E.g If machine had Adobe Flash Player 10 and Donkey Kong 12.0.0.70 (for example) it won't appear
Hope someone can help
Thanks
-
I have found the only way to accomplish this is by editing the resulting SQL. - kcsc 10 years ago
Answers (3)
I have better luck using "begins with" for my software titles than "contains"
Try that
Your != should work properly to give you versions below 12.0.0.70
Comments:
-
Thanks for replying. Already tried using "begins with" - No joy - DriveBlind 10 years ago
I am in the same boat. New to KACE. The only way I have found to accomplish this is by editing the SQL after creating the smart label. I have almost zero knowledge of SQL. But I was able to look at the SQL and pinpoint the section dealing with version number (it's long!). I noticed the part dealing with "name equals Flash" was enclosed in parentheses, then "AND less than 12" was separate after that. I was able to drag the entire "AND less than 12" section inside the parentheses with the "name equals" statement, thus making "name equals Flash AND version less than 12"
hope that makes sense. this seems to be something a lot of people would want to do, but there is no way to "AND" in this fashion through the GUI.
Comments:
-
Thanks for the reply kcsc - you were spot on
KACE support have confirmed that the query I built is working as expected - it WILL NOT return machines that have got Adobe Flash Player AND Adobe Flash Player is not equal to 12.0.0.70. The only way to get the desired results is to edit the SQL as you suggested
Thanks again - DriveBlind 10 years ago-
good deal, glad i could help. i hear KACE 6.0 is coming by the end of April. Lots of GUI changes, hopefully there is a better SQL statement builder. - kcsc 10 years ago
I ran this same query and it worked correctly for me. I feel like this hotifx fixed searching weirdness for me...have you applied it?
http://www.kace.com/support/resources/kb/solutiondetail?sol=SOL116901
Comments:
-
I applied that hotfix a while back. I've logged a support ticket about this issue. I'll report back with the findings. In the meantime if anyone else has got any ideas / suggestions I would love to hear from them.Cheers - DriveBlind 10 years ago