How to exclude an application patch from updating using K1000
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
Answers (4)
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)')
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%')
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.
I know you think they would have increased the number by now, thank for your comments. The Pipes will go the job.