PowerShell / SQL Server / Check SQL Server current Update Status and send Email Report

Script Download:

The script with usage example is available for download from https://gallery.technet.microsoft.com/Use-PowerShell-to-check-05ca591f

Summary:

Check SQL Server Version and the current patch level for all servers you specified. As well check latest patches/updates available for installed SQL Server version and send email with results.

Description:

SQL Server Instance Update Status PowerShell script which can be invoked remotely from another PC trough the command line, with PowerShell or executed remotely through task scheduler adding servers names. Script is checking server registry values for (Version, PatchLevel, Edition, SQLPath), you can choose and add other values from registry if needed. After that, script compare version installed and grab RSS Feed values with all updates available for that particular version.

I am using my RRS Feeds (https://blog.sqlserveronline.com/category/updates/feed/?withoutcomments=1), customized for my needs, but you can create your own, or to use RSS from other sources, such as http://sqlserverupdates.com/feed/ (Excellent web page, all update information you need, Brent Ozar). I have RSS feed for the SQL Server Version 2012 and newer. I am suggesting using proxy to connect to any outside RSS Feeds, in this example your SQL Server Instances need internet connection.

 

Similar Posts:

One Response to “ “PowerShell / SQL Server / Check SQL Server current Update Status and send Email Report”

  1. Felipa says:

    Enjoyed examining this, very good stuff, thanks .

Leave a Reply

Your email address will not be published. Required fields are marked *