Hi there,

I was wondering if anyone else was having this issue. Occasionally, I'll make a patch smart label for instance. After it's been created using the wizard, I'll look at it in label management and it'll have say 50 patches or whatever. Then I go to modify it and the smart label wizard will say there are no patches.

I've seen this happen with device and software labels as well. I feel like it was a bug, but I thought they fixed that.

Any ideas anyone?

Thanks.
Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • can you post an example? IE the SQL of one of the problematic smart labels
    • SELECT UNIX_TIMESTAMP(RELEASEDATE) as DATEPOSTED_SECONDS, KBSYS.PATCHLINK_PATCH.IS_APP, KBSYS.PATCHLINK_PATCH.IMPACTID AS DESCRIPTION, KBSYS.PATCHLINK_PATCH.RELEASEDATE AS DATEPOSTED, KBSYS.PATCHLINK_PATCH.IS_SUPERCEDED, KBSYS.PATCHLINK_PATCH.DESCR, KBSYS.PATCHLINK_PATCH.ID AS BID, KBSYS.PATCHLINK_PATCH.UID AS UID, KBSYS.PATCHLINK_PATCH.IDENTIFIER AS BULLETINID, KBSYS.PATCHLINK_PATCH.STATUSID AS STATUS, KBSYS.PATCHLINK_PATCH.TYPE, KBSYS.PATCHLINK_PATCH.VENDOR, UNPATCHED, YEAR(KBSYS.PATCHLINK_PATCH.RELEASEDATE) as DATEPOSTED_YEAR, PATCHED, KBSYS.PATCHLINK_PATCH.TITLE, KBSYS.PATCHLINK_IMPACT.IMPACT_SEQ, PATCHLINK_PATCH_STATUS.STATUS AS PATCH_STATUS, CACHE_SIZE AS CACHE_SIZE, KBSYS.PATCHLINK_PATCH.ID as TOPIC_ID FROM KBSYS.PATCHLINK_PATCH left join PATCHLINK_PATCH_COUNT on PATCHLINK_PATCH_COUNT.PATCHUID = KBSYS.PATCHLINK_PATCH.UID join KBSYS.PATCHLINK_IMPACT ON KBSYS.PATCHLINK_IMPACT.IMPACT=KBSYS.PATCHLINK_PATCH.IMPACTID left join PATCHLINK_PATCH_STATUS on PATCHLINK_PATCH_STATUS.PATCHUID = KBSYS.PATCHLINK_PATCH.UID WHERE ((KBSYS.PATCHLINK_PATCH.TITLE like '%Firefox%') AND (KBSYS.PATCHLINK_PATCH.IS_SUPERCEDED = '0') AND ((TIMESTAMP(KBSYS.PATCHLINK_PATCH.RELEASEDATE) <= NOW() AND TIMESTAMP(KBSYS.PATCHLINK_PATCH.RELEASEDATE) > DATE_SUB(NOW(),INTERVAL 6 MONTH))))
Please log in to comment

Answer Chosen by the Author

0
Hello,

when you create a patch smart label the view is filtered. You need to pay attention on the View by and Show at the top of the view.
yAKODQ.png

The smart label will apply to all the patches in the database regardless the settings of the view.
To amend them I'd suggest to go in Security -> Patch Catalog, amend them setring "Show" to "Individual Patches" and "View By" to "All Patches" and then return to the labels interface.
 I hope this will help.
Kind regards,
 Marco - StockTrader
Answered 12/14/2015 by: StockTrader
Red Belt

  • Unfortunately, that has not resolved the issue. I've selected the View and Show By to show any patches. I then set the only criteria to show any patches that contain the a given name, "firefox" for instance, and nothing shows up. However in my label there is more criteria and one patch is associated with it.
    • just to confirm: you've set "Show" to "Individual Patches" and "View By" to "All Patches"?
      • Yup, that's it... Wow, that seems almost absurd that you have to set that a certain way for patch labels, you'd think that would be defaulted. can you update your answer to include the show individual patches part and I'll mark it as best answer?
    • I modified my answer to clarify it...anyway..does it work now?
      Kind regards,
      Marco - StockTrader
      • Perfecto! Thanks Again for your help!
Please log in to comment

Answers

Answer this question or Comment on this question for clarity

Share