Check whether MS SQL server had installed KB4583461

Question

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.

Answer 1

Hi @Leong Yew Cheong ，

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.

Answer 2

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.

Answer 3

"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

Answer 4

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