Estate -> Installed Versions doesn't show latest release of SQL Server 2017

bauerju

Hi
I can only see CU12 for Sql Server 2017.

As my Sql Monitor installation can't get through my firewall, I need to update the versions json, which lies at C:\ProgramData\Red Gate\SQL Monitor\SqlServerVersions.json myself with a powershell script. 
So getting it from https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json gets me only CU12. 
But since 18 Dec. 2018 there is CU13 (gives build 14.0.3048.4) and since 8 Jan 2019 the hotfix 1 for CU13 (gives build 14.0.3049.1) is available. 
But these cann't be found in the json.  

Jürgen

Alex B

Hi @bauerju,

After discussing with @Russell D, SQL Monitor polls gets the json from the Redgate website every 6 hours, though when specifically that is or is triggered is a bit of an unknown at the moment.

The json itself may or may not have been updated to include the latest versions.  Having said that, I've just downloaded the json from https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json and it has CU13 included, so it would seem it's just a matter of time before this is reflected in the UI.

Work is being done on this process, so this is subject to change, but that's how it currently sits at the moment.

Kind regards,
Alex

Alex B

Hi @bauerju,

This has just been updated and should be available in the next release.  You if you are editing the file anyway, you should be able to add the following at the end of the section for version 2017 (between 2017 and 2019):

<div>   {
&nbsp; &nbsp; &nbsp; "Edition": "2017",</div><div>&nbsp; &nbsp; &nbsp; "ProductLevel": "RTM CU12",
&nbsp; &nbsp; &nbsp; "Version": "14.0.3045.24",
&nbsp; &nbsp; &nbsp; "ReleaseDate": "2018-10-25",
&nbsp; &nbsp; &nbsp; "EndOfSupportDate": "2022-10-11",
&nbsp; &nbsp; &nbsp; "DownloadUrl": "https://support.microsoft.com/en-us/help/4464082/cumulative-update-12-for-sql-server-2017"
&nbsp; &nbsp; },</div>

I hope that helps!

Kind regards,
Alex

Russell D

Just to add to Alex's comment - we do not track hotfixes on this page (see the note on this page: https://documentation.red-gate.com/sm8/versioning-and-patching), so the 8th Jan hotfix won't be on that page. You can add it manually using the json syntax above though.

bauerju

Hi Alex B , Hi Russell D
I just installed the new release ( 8.0.26.19750 ) same problem here. Also the download shows only CU12.
There is a job which downloads the file every day, so editing it won't fix it.
 
Jürgen

bauerju

Hi Alex B
Latest download did it.

Thanks

Jürgen