PowerShell / SQL Server / Check SQL Server current Update Status and send Email Report
Posted by Barac in Powershell, SQL Server on Mar 1st, 2018 | 2 commentsScript 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:
- SQL Server / PowerShell / Check SQL Server version and a current patch level for all servers you specify using PowerShell
- Powershell / Use PowerShell to Backup all user databases to Azure Storage
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
2 Responses to “ “PowerShell / SQL Server / Check SQL Server current Update Status and send Email Report”
Leave a Reply
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
Enjoyed examining this, very good stuff, thanks .
Sorry I cannot find the file. Can you check to see if it is present