Hi all-

I'm attempting to create a Patch Label that shows me all of my patches on the KBOX that are newer than 40 days. I thought I could do this by creating a new Smart Label in the Patch module, and using the following criteria

Release Date < DATE_SUB(now(), INTERVAL 40 DAY)

When I test the label, instead of getting only patches that have been released in the last 40 days, I get every patch in my patch listing, regardless of the release date. Am I using the wrong criteria? Thank you for any assistance!

2 Comments   [ + ] Show Comments

Comments

  • Can you post the SQL query for the smart label? The wizard doesn't always format them correctly and they sometimes need to be adjusted.
  • Hi chucksteel....this is it in its simplest form

    select UID from KBSYS.PATCHLINK_PATCH where ( KBSYS.PATCHLINK_PATCH.RELEASEDATE < 'DATE_SUB(NOW(),INTERVAL 40 DAY)')
Please log in to comment

Answers

0

it may be the space between the comma and interval

https://kace.uservoice.com/forums/82699-k1000/suggestions/2224921-allow-last-days-for-patch-release-date-search

Answered 12/06/2013 by: SMal.tmcc
Red Belt

  • Unfortunately there was no change when I removed the space.
    • sorry I cant look into that further our server crew crashed the kbox doing a patch.
Please log in to comment
Answer this question or Comment on this question for clarity

Share