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?

3 Comments   [ + ] Show Comments

Comments

  • Although it may not solve your problem, I've had better luck using "!=" rather than "does not contain". Can you post the SQL that it generates? That would help.
  • I have tried both
  • SQL CODE BELOW, this was created with the 2 filter rules mentioned in the original post


    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
Please log in to comment

Answers

0

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

Answered 12/18/2013 by: awingren
Eighth Degree Black Belt

Please log in to comment
0

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
Answered 10/03/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share