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?
Answers (2)
Hello Jrasmussen,
I too am having this problem. I thought the whole point to the smart label improvements was so we would be forced to do less SQL, not more!
There's a good possibility I just don't understand how to properly use the "and" vs "or".
~awingren
Try this.
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
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_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%pdfcreator%')) ) AND (SOFTWARE.DISPLAY_VERSION not like '%1.7.1%')) GROUP BY MACHINE.ID - jrasmussen 10 years ago