OR (1 in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JTĪnd SOFTWARE.DISPLAY_NAME rlike 'Java 2 Runtime Environment|J2SE Runtime Environment 5.0')) )) Where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.IDĪnd (SOFTWARE.DISPLAY_NAME like '%Java(TM)%'Īnd SOFTWARE.DISPLAY_VERSION RLIKE '(^])|(^6]0](|30)$)'))) )
WHERE ((( (1 in (select 1 from ORG1.SOFTWARE, ORG1.MACHINE_SOFTWARE_JT LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1 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' _
ADOBE FLASH PLAYER 11.2.0 WINDOWS 10 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)
