Symptoms

Version name is missing for SQL 2014, 2016, 2017 Discovery - when using the "Windows - MSSQL" Probe.

Release

Any

Instance is configured to use "Windows - MSSQL" Probe for SQL server discovery. With this probe, it will only populate the version up to 2012.

To check:
Navigate to -> Discovery Definition -> Processes -> Microsoft SQL Server -> Triggers Probe ->

"Powershell-Windows-MSSQL" should be "active" one if there is 2.

Sensor:

Navigate to -> Discovery Definition -> Sensors -> "Windows - MSSQL"

line 58 to 75 - shows that Version available is up to 2012.

1. Use Pattern instead of Probe.

If Probe is preferred instead of Pattern then below is the possible workaround/customization.

1. Add follow to the script. (ref: http://sqlserverbuilds.blogspot.com/ )

Navigate to -> Discovery Definition -> Sensors -> "Windows - MSSQL"

--

case '14':

return '2017';

case '13':

return '2016';

case '12':

return '2014';

------

2. Add a choice list.

1. Navigate to -> Discovery definition -> Tables -> MSFT SQL Instance -> Table Column (Version name) -> Under the Related Link -> Choice

2. Add the choice 2014,2016,2017 and follow the sequence.