question

LeongYewCheong-0616 avatar image
0 Votes"
LeongYewCheong-0616 asked Yufeishao-msft commented

Check whether MS SQL server had installed KB4583461

Hi,

We are running MSSQL 2016 SP2 with CU17 installed. Auditor has asked whether KB4583461 is installed in the server. Is there a way to check as KB4583461 is old than the current CU? Is there a log file to check?

Thanks.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft commented

Hi @LeongYewCheong-0616

you can refer to this article:

Check the Windows Update history or View installed updates in Programs and Features Control Panel to see what you have downloaded



If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Could you please validate all the answers so far and provide any update?

Please do not forget to mark as accepted answer wherever information provided to you were helpful.

Regards

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Run the query

 select @@version

to get the build number and compare it with the list at https://sqlserverbuilds.blogspot.com/

KB4583461 is "old", it's CU15 from january 2021
You have a newer SP 2 CU17 installed, it include all previous CU.
So the answer is yes, the fix is installed.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

"Cumulative Updates" include all previous updates.

KB4583461 updates to version 13.0.5865.1. Any version >=13.0.5865.1 has the update. You can see your version by running SELECT @@VERSION.


https://support.microsoft.com/en-us/topic/kb3177312-sql-server-2016-build-versions-d6cd8e5f-4aa3-20ac-f38f-8faef950840f

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeongYewCheong-0616 avatar image
0 Votes"
LeongYewCheong-0616 answered

Is there a way to show or retrieve from any log to prove that KB4583461 had been installed previously to satisfy auditor ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.