/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How to exclude an application patch from updating using K1000

02/26/2014 2330 views

Hi

I have created an smart label with the below 4 feilds but want to add two more feilds to exclude updates to citrix and java patches. But as you only have 4 feilds and I can't write in sql query how can I stop updates to citrix and java application patches in my smart label?

  • Win 7 SP1 x64
  • Critical
  • APP
  • Active

Thanks

carl

 

 

 

 

0 Comments   [ + ] Show comments

Comments


All Answers

0

You can have more than 4 lines with the 5.5 release of K1000. Have you upgraded to that?

As for the exclusions, here's a sample that I did to exclude Microsoft, Mozilla, McAffe, Novell, Trend Micro and Ctrix patches. You don't need to be a SQL expert to modify your existing smart label. Play around with it using my example as a template.

select UID from KBSYS.PATCHLINK_PATCH where (  KBSYS.PATCHLINK_PATCH.VENDOR not rlike '(microsoft|novell|mcafee|trend micro|mozilla|citrix)')

Answered 02/26/2014 by: rockhead44
Red Belt

0

Hi Rockhead thanks for the reply I am using version 5.5.90545 for K1000. Some smart labels allow you to create more than 4 line but a patch smart label is limited to 4 lines, if there is a way to increase the number of lines please let me know?

My smart label seems slighlty different (see below) its using %% where yours uses () I will test both.

AND KBSYS.PATCHLINK_PATCH.TITLE not like '%citrix%')

 

 

Answered 02/27/2014 by: bullet2000
White Belt

0

I didn't realize the patch smart label was still limited. As for the smart label itself, in my case I used pipes to separate the vendors. 

Answered 02/27/2014 by: rockhead44
Red Belt

0

I know you think they would have increased the number by now, thank for your comments. The Pipes will go the job.

Answered 02/27/2014 by: bullet2000
White Belt

Don't be a Stranger!

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

Sign up! or login

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