Post reply

SQL server service pack,hotfix applied dates

  • December 20, 2016 at 7:08 am

    #333073

    Hello,

    Found Powershell script in below blog to list the last install date and time for windows updates on servers.

    https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca

    Is there any way we can get SQL server service pack,hotfix applied dates?

    Thanks in advance

    Regards,

  • December 20, 2016 at 7:46 am

    #1918918

    Sreejith! (12/20/2016)

    Hello,

    Found Powershell script in below blog to list the last install date and time for windows updates on servers.

    https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca

    Is there any way we can get SQL server service pack,hotfix applied dates?

    Thanks in advance

    Regards,

    This information is available if you open Programs and Features / View Installed Updates, therefore the answer is 'yes' : you just need to work out how to read the right bit of the Registry.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 20, 2016 at 8:58 am

    #1918943

    Thanks for the reply.Unfortunately there is no log(date attribute) which tells us when registry key was created or edited

  • December 20, 2016 at 9:55 am

    #1918970

    Sreejith! (12/20/2016)

    Thanks for the reply.Unfortunately there is no log(date attribute) which tells us when registry key was created or edited

    OK, fair point. I think that you will find this information in Win32_Product.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 22, 2016 at 6:42 am

    #1919318

    No luck with Win32_Product as well 🙁

  • December 22, 2016 at 10:52 am

    #1919398

    Sreejith! (12/22/2016)

    No luck with Win32_Product as well 🙁

    Sorry, I'm out of ideas.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 23, 2016 at 7:45 am

    #1919525

    Try looking in the registry as per https://ask.sqlservercentral.com/questions/109215/querying-installation-history-for-sql-server.html

  • December 26, 2016 at 10:02 pm

    This was removed by the editor as SPAM

  • December 27, 2016 at 9:57 pm

    #1919817

    Thanks 🙂

    The long hex-named subkeys in the registry path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\. cotains infomation about patch installed date.

    Now the challenge is to search through the Hexadecimal folders ,for InstallProperties subfolders and search for DisplayName = SQL Server 2008/2012/2014* and then retrive the InstallDate.Is there any way we do it with T-sql?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply