Patching - Label not working correctly when trying to use Release Date
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
Answers (1)
Please log in to answer
Posted by:
SMal.tmcc
11 years ago
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
Comments:
-
Unfortunately there was no change when I removed the space. - dtobias_keenan 11 years ago
-
sorry I cant look into that further our server crew crashed the kbox doing a patch. - SMal.tmcc 11 years ago
select UID from KBSYS.PATCHLINK_PATCH where ( KBSYS.PATCHLINK_PATCH.RELEASEDATE < 'DATE_SUB(NOW(),INTERVAL 40 DAY)') - dtobias_keenan 11 years ago