Jump to content
nyoder@mapletronics.com

computers.windowsupdate field changes to 01/01/01/1901 after Patch Remedy Runs

Recommended Posts

I'm having an issue that I believe is related to Patch Remedy. It seems after Patch Remedy runs, I get hundreds of tickets triggered from the UPDATES- Out-of-Date monitor. The computer.windowsupdate field is populated with 01/01/1901 01:01:01. This doesn't happen every time PR runs. However, everytime it happens PR is the last script ran. I have setup an autofix to fix it when it happens but I would like to eliminate the cause. Any ideas?

Share this post


Link to post
Share on other sites

I am seeing this exact issue and I think it has to do with Patch Remedy as well.

Share this post


Link to post
Share on other sites

You could update the monitor to put a lower limit on the date, which would exclude those 1901 values. In the additional condition, add: 

AND STR_TO_DATE(computers.WindowsUpdate,'%m/%d/%Y %H:%i:%s')>DATE_ADD(NOW(),INTERVAL -30 YEAR)

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×