/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Smart label question. Need someone to double check my setup.

01/15/2015 1308 views

I have created a few smart labels to find systems that not get some patches. All of these patches start with the same name "NoPatch" and a keyword. No spaces in the label name. Right now I am trying to create a label to patch all of our other workstations that can get all of the approved patches. They way i am trying to do is by making a smart label that finds all systems the do not contain a label with "NoPatch" The problem is that this smart label seems to be getting all systems regardless of its label. And the "NoPatch" smart labels are getting some but not all of the systems the should be excluded. Here is the code of the 2 smart labels created using the wizard. Can anyone spot the issue with them? 


SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE  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 '%softwarekeyword%')) ))
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE  WHERE (((not exists (select 1 from LABEL, MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID  AND LABEL.TYPE <> 'hidden' and LABEL.NAME like '%NoPatch%')) ) AND (OS_NAME not like '%server%'))  
0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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