Wrong version entered in info.SQLInfo for SQL 2016 Servers
Do you want to request a feature or report a bug? Bug
What is the current behavior? SQL 2014 is entered in the SQLVersion column of info.SQLInfo instead of SQL 2016.
**If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem via https://jsfiddle.net Add a SQL 2016 server to InstanceList and run the dbareports - SQL Server Information job.
What is the expected behavior?
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures? OS - Windows 2012 R2 SQL - SQL 2016 13.0.2164
Code is wrong in SQLInfo.ps1
if ($VersionMajor -eq 12) { $Version = 'SQL 2014' } if ($VersionMajor -eq 13) { $Version = 'SQL 2014' }
Fixed and created PR.
Just found this bug in the version I installed from the Gallery. Any ideas when this fix will make it into the version on the gallery?