/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Smart Label logic for software version is greater or less then?

03/17/2020 486 views

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!


0 Comments   [ + ] Show comments

Comments


All Answers

0

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

Answered 03/17/2020 by: KevinG
4th Degree Black Belt

  • 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])$)'
 
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