How do you find out what version of SharePoint or Project Server 2007 you are running?

  • Article

The first approach is to open a web browser and got to the site settings page

(Site Actions > Site Settings > Modify All Settings).

 

The second approach is against the databases. Open SQL Server Management Studio, Connect to the server, new query, run the following:

 

Use Sharepoint_ConfigDb

 

SELECT *

 

FROM Versions

 

WHERE VersionId = '00000000-0000-0000-0000-000000000000'

 

ORDER BY Id DESC

 

This returns (columns reduced for readability):

 

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.

 

You can also look at the versions for Content Databases, by changing the database name. For example: FROM WSS_Content_MySites.[dbo].[Versions]

 

 

MOSS Product Version

 

MOSS 2007 OCT Cumulative update 12.0.0.6331

 

MOSS 2007 Aug Cumulative update 12.0.0.6327

 

MOSS 2007 Infrastructure Update 12.0.0.6318

 

MOSS 2007 post SP1 hotfix KB948945 12.0.0.6303

 

MOSS 2007 post SP1 hotfix KB941274 12.0.0.6301

 

MOSS 2007 post SP1 hotfix KB941422 12.0.0.6300

 

MOSS 2007 SP1 12.0.0.6219

 

MOSS 2007 October public update 12.0.0.6039

 

MOSS 2007 August 2007 hotfix 12.0.0.6036

 

MOSS 2007 RTM 12.0.0.4518

 

FOR PROJECT SERVER 2007

**************************

 

Use ProjectServer_Published

 

SELECT *

 

FROM Versions

 

WHERE VersionId = '00000000-0000-0000-0000-000000000000'

 

ORDER BY Id DESC

 

 

 

*For Project Client you can check from Project Professional >>Help >>About Microsoft Office Project