Smart Label Problems K1000 5.5
We recently updated our K1000 to v5.5
Since the update when I try to make a smart label for software updates by filtering by software title and version, the smart label fails to remove computers with the correct version number from the smart label. This happens both when testing a new label I try to create or if I actually create a label and let it run. In the end it is not a huge problem because the distribution system will not push to a machine the update is already on, but I like to filter the smart labels this way just to keep things cleaner.
I am simply trying to filter by for example Software Title Contains PDFCreator
AND Software Version DOES NOT CONTAIN 1.7.1
Anyone else run into this problem or have any suggestions for me?
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID) LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID) where ((( (1 in (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME = 'PDFCREATOR')) ) AND (1 not in (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_VERSION = '1.7.1')) )) GROUP BY MACHINE.ID