LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID Select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE Smart label to catch all pre-6u31 installs of Java ("wizard-built" modified smart label): The second statement (separated by "OR") uses:ġ) A REGEX to match 'Java 2 Runtime Environment' or 'J2SE Runtime Environment 5.0' _
#Regex for number should be less tah 500 software
So I combined two statements to catch all Java versions without the Java Updater and merged them into a wizard-generated smart label.ġ) Software Titles contains 'Java(TM)' 2) The regex statement above However, I found that in practice (and an earlier Inventory - Software search) that this would end up missing the Java 2 & 5 installs and catch machines running the Java Updater application, as well as throwing in other things that I didn't want. Note - Don't use this, it really doesn't work well. Select MACHINE.ID from MACHINE JOIN MACHINE_SOFTWARE_JT MS ON MACHINE_ID=MACHINE.IDĪND DISPLAY_VERSION RLIKE '(^])|(^6]0](|30)$)' group 2 -> 300 through 309 _Ĭorresponding smart label (for catching any machines with Java versions below 6.0.310): * long separated clause catches in groups * find anything matching 6.0.0 through 6.0.309 So building a regex for catching any versions below 6.0.310 (the current version of Java) would be: * separated clause also catches in groups
Using REGEX in Smart Labels to Find Lower Versioned Software (w/Java Example)Īs discussed in multiple posts, the Software Version "number" is not stored as a number by the KBOX, so using " 1 through 9 * should probably be
0 kommentar(er)
