/build/static/layout/Breadcrumb_cap_w.png

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?


3 Comments   [ + ] Show 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. - dugullett 9 years ago
  • I have tried both - jrasmussen 9 years ago
  • 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 - jrasmussen 9 years ago

Answers (2)

Posted by: awingren 8 years ago
8th Degree Black Belt
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

Posted by: dugullett 9 years ago
Red Belt
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
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ