Check whether MS SQL server had installed KB4583461

Leong Yew Cheong 21 Reputation points
2021-12-03T13:19:52.95+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,288 questions
0 comments No comments
{count} votes

Accepted answer
  1. YufeiShao-msft 7,041 Reputation points
    2021-12-06T02:01:59.587+00:00

    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.


3 additional answers

Sort by: Most helpful
  1. Olaf Helper 38,941 Reputation points
    2021-12-03T13:33:47.327+00:00

    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.

    0 comments No comments

  2. Tom Phillips 17,711 Reputation points
    2021-12-03T15:47:27.173+00:00

    "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

    0 comments No comments

  3. Leong Yew Cheong 21 Reputation points
    2021-12-04T00:41:33.543+00:00

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

    0 comments No comments