none
How to get a list of installed MOSS 2007 updates?

    Question

  • We have several problems with our MOSS 2007 installation and operation and since we found out that two identical sharepoint servers (production and test) that had same updates applied have different Search_DB databases (they have same name function with different number of parameters, for ex.) we have a single idea of what can be the cause:

    Somehow, windows update or other quirk, an update or hotfix got applied to one of the servers. 

    Strange thing is, noone of our employees seems to know, neither google seems to know, how do we exactly get a list of installed updates on the MOSS 2007 installation.

     

    So, simple question: HOW? How do we get a complete list of changes (hotfixes, servicepacks, patches) done to an installation of MOSS?

    Friday, September 03, 2010 10:47 AM

Answers

  • Version information is stored in a number of places.

    The list of hotfixes/patches on each server is obviously in add/remove programs (show updates).

    The version number of each server can be seen in 'Servers in Farm' in Central Administration

    The version number of each config/contentdb can be obtained via a SQL Query.

    These version numbers may all be out of sync depending on if psconfig has been run on all the servers and respective databases.

     

    Cheers,


    Conrad


    Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 11:28 AM
  • Hi,

    The binaries installed on the server: Take a look at the registry on theSharePoint Servers for the following HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\BuildVersion\12.0.6425.1000 where the build version on your environment will be different than the one I used in the example...

    The following SQL Query will list the updattes that have been applied.

    SELECT [VersionId]
          ,[Version]
          ,[Id]
          ,[UserName]
          ,[TimeStamp]
          ,[FinalizeTimeStamp]
          ,[Mode]
          ,[ModeStack]
          ,[Updates]
          ,[Notes]
      FROM [SharePoint_Config].[dbo].[Versions]
      WHERE VersionId = '00000000-0000-0000-0000-000000000000'
      ORDER BY Id DESC

    VersionId Version Id UserName Updates
    00000000-0000-0000-0000-000000000000 12.0.0.6219 4 MOSS\user 3
    00000000-0000-0000-0000-000000000000 12.0.0.4518 1 MOSS\user 2

    The top row is the latest version.  The query is performed on the SharePoint Configuration database.  If you have called this database something instead of "SharePoint_Config" change the query to reflect this.

    -Ivan


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 11:45 AM
  • Hi,

    Use regedit and check the following for SharePoint 2007

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\OfficePremium REG_SZ 1 is Enterprise

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\OfficePremium REG_SZ 0 is Standard

    -Ivan 

     


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 12:06 PM

All replies

  • Version information is stored in a number of places.

    The list of hotfixes/patches on each server is obviously in add/remove programs (show updates).

    The version number of each server can be seen in 'Servers in Farm' in Central Administration

    The version number of each config/contentdb can be obtained via a SQL Query.

    These version numbers may all be out of sync depending on if psconfig has been run on all the servers and respective databases.

     

    Cheers,


    Conrad


    Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 11:28 AM
  • Hi,

    The binaries installed on the server: Take a look at the registry on theSharePoint Servers for the following HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\BuildVersion\12.0.6425.1000 where the build version on your environment will be different than the one I used in the example...

    The following SQL Query will list the updattes that have been applied.

    SELECT [VersionId]
          ,[Version]
          ,[Id]
          ,[UserName]
          ,[TimeStamp]
          ,[FinalizeTimeStamp]
          ,[Mode]
          ,[ModeStack]
          ,[Updates]
          ,[Notes]
      FROM [SharePoint_Config].[dbo].[Versions]
      WHERE VersionId = '00000000-0000-0000-0000-000000000000'
      ORDER BY Id DESC

    VersionId Version Id UserName Updates
    00000000-0000-0000-0000-000000000000 12.0.0.6219 4 MOSS\user 3
    00000000-0000-0000-0000-000000000000 12.0.0.4518 1 MOSS\user 2

    The top row is the latest version.  The query is performed on the SharePoint Configuration database.  If you have called this database something instead of "SharePoint_Config" change the query to reflect this.

    -Ivan


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 11:45 AM
  • Thank you both i will try that, meanwhile, we have a more stupid question (sorry). 

    How do we know if we have Standart or Enterprise MOSS? We installed from a "Standart and Enterprise" distributive and the key is given to us by another employee, who is now out of reach. We dont actually know which version got installed, and in "add and remove programs" it doesnt specify if its standart or enterprise...

    Friday, September 03, 2010 11:57 AM
  • Hi,

    Use regedit and check the following for SharePoint 2007

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\OfficePremium REG_SZ 1 is Enterprise

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\OfficePremium REG_SZ 0 is Standard

    -Ivan 

     


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    • Marked as answer by Istrebitel Monday, September 06, 2010 12:05 PM
    Friday, September 03, 2010 12:06 PM
  • can it be used to get the versions of _Search_DB? 

    We have two identical (production and test) servers and they have dirderent Search_DB's

    --

    what does it mean when it shows different versions for different usernames?

    Like this:

     

    VersionId Version Id UserName TimeStamp FinalizeTimeStamp Mode ModeStack Updates Notes

    00000000-0000-0000-0000-000000000000 12.0.0.6421 1 DOCPORTAL\spserver 2009-08-03 08:29:20.313 NULL 0 0 4

    00000000-0000-0000-0000-000000000000 12.0.0.6514 4 DOCPORTAL\avandronov 2010-09-01 13:20:13.157 NULL 0 0 7

     

    Friday, September 03, 2010 12:08 PM
  • Looks like the user who installed the CU 12.0.0.6514 was AVandrono on 09/01/2010 installed (August 2009 CU)...  user SPServer on 08/03/2009 12.0.0.6421 installed (SP2)..Probably requested the wrong CU thinking it was the August 2010 CU

    Here are the August 2010 CUs

    Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (WSS server-package): August 31, 2010 http://support.microsoft.com/kb/2276474

  • Description of the Office SharePoint Server 2007 Cumulative Update server hotfix package (MOSS server-package): August 31, 2010 http://support.microsoft.com/kb/2276472

     

    -Ivan


  • Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
Friday, September 03, 2010 12:17 PM