Smart Label logic for software version is greater or less then?
Greetings,
I've been having some difficulty setting up smart label logic for a software title being less or greater than.
I've tried setting up groups as follows but the software version and title search are being handled as separate items, and the version logic is getting applied to every software title on the system .
Example
[Some logic here]
[ Software Title] = McAfee Agent
[Software Version] < 5.6.1.308
Is there a way I can apply the search to the versioning of a specific software title using the built in queries or would someone be able to provide some SQL logic that I could adapt for this?
Thanks!
Answers (2)
See my responses on these previous posts for some ideas:
https://www.itninja.com/question/trying-to-write-a-label-to-match-if-flash-version-is-less-than-21-0-0-213
https://www.itninja.com/question/kace-k1000-smart-label-smart-label-for-latest-or-max-software-version
The use of regex can come in handy when checking software versions.
https://support.quest.com/kace-systems-management-appliance/kb/115858/smart-label-filters-do-not-work-with-software-version
Comments:
-
Thanks, that helps quite a bit.. The regex statement is defiantly fairly messy and hard for me to follow.
The SQL portion will be super easy though. Are the tables referenced in this document still valid with SMA 10.?
Can you recommend any specific site or tool that can assist in generating logic such as below?
Regex statement to catch anything below 10.3.181.26 (i.e. 10.3.181.25 & below):
'(^[0-9][[.period.]])|(^10[[.period.]][0-2][[.period.]])|(^10[[.period.]]3[[.period.]]([1-9]|[1-9][0-9]|1[0-7][0-9]|180)[[.period.]])|(^10[[.period.]]3[[.period.]]181[[.period.]]([0-9]|1[0-9]|2[0-5])$)' - Kiyolaka 4 years ago
