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?

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, ConradConrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

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. -IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.

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...

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.

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

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.