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

Please log in to comment

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
Tenth Degree Black Belt

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

Please log in to comment
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
Tenth Degree Black Belt

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

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

Share