Estate -> Installed Versions doesn't show latest release of SQL Server 2017
bauerju
Posts: 33 Bronze 3
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
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
Tagged:
Best Answer
-
Alex B
Posts: 1,157 Diamond 4
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
Answers
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> { "Edition": "2017",</div><div> "ProductLevel": "RTM CU12", "Version": "14.0.3045.24", "ReleaseDate": "2018-10-25", "EndOfSupportDate": "2022-10-11", "DownloadUrl": "https://support.microsoft.com/en-us/help/4464082/cumulative-update-12-for-sql-server-2017" },</div>I hope that helps!Kind regards,
Alex
Have you visited our Help Center?
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
Latest download did it.
Thanks
Jürgen