Net Framework%' )) ) *****SECOND LINE OF SMART LABEL BEGINS HERE***** AND ((not exists (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_VERSION like '%4.7.2%')) )) SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((( exists (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%Microsoft. See in nested example below.Įxample Original SQL (Used stars to denote where the second line of the smart label begins):
CHECK VERSION OF NET INSTALLED SOFTWARE
To make this more confusing, since we are removing a portion of the code which has NOT in front of the second check, we need to add "not" in front of the software version "like" statement, in order to make sure we are looking for machines WITHOUT version 4.7.2 installed. In essence, you copy the last "and" statement of the second-line-of-the-smart-label check and paste it just after the last "and" statement of the first line's check, then remove the second line check from the code (but make sure there are still enough closing parenthesis). (navigate to the Smart Label and click the Edit SQL button at the bottom of the label details) To correct this issue, you can edit the SQL code generated by the smart label and nest the version check into the software title check.
NET but also a different software that IS version 4.7.2, it will still be left off the list of machines this smart label pulls. Not that it is the most common version number, but if by chance a machine had a lower version of.
NOTE: the second line in the above smart label will check ALL software for version 4.7.2