Patch compliance report

• Innerise

  Ten Centuries

  Points: 1020

  More actions

  May 23, 2013 at 1:33 pm

  #394840

  Hello everyone

  I want to set up a new process at work, whereby each of our SQL Server instances (2000 up to 2012) are checked for patch compliance on a monthly basis.

  It'd be nice to automate this and have a pretty report produced and emailed out, showing the build/patch version of each instance and how out of date they are. Any other information, such as the number of available patches for each server, would be a bonus.

  Is anyone already doing this and, if so, how? I've seen WSUS in action, but didn't think much of the reporting side of things. I've heard that SolarWinds Patch Manager is quite good, but it comes at a cost. Maybe even PowerShell could be used, but there must be some manual intervention when checking for the latest SQL Server patches (i.e. manually updating the script each time a new patch is released by Microsoft).

  Anyway, your thoughts would be appreciated.

  Thanks,

  Innerise