Determine the version of Project Server 2010 Installed

I always have a hard time finding how to determine what version of update is installed on the Project Server.  Since I finally found it again I decided to create a post about it so next time I can just refer to my own blog.  Hopefully by having it in more than just Brian Smith’s Blog will also help others find it as well.

This is an excerpt of the post located at http://bit.ly/cHxHPW by Brian Smith.  I cannot take credit for this content.

Depending on where you look you will see different versions.  Some updates also do not make changes to the database and therefore do not always modify the database version information.  As you can see with June, August, and October where the database versions for Project are all the same.

Other place to look version information is in the Control Panel, Programs and Features (binary version) or on the individual binaries – which is also listed in Central Administration under Upgrade and Migration, Check Product and Patch Installation Status. 

To get the version information from the database use the following query.

USE <PROJECTSERVERNAME>_Published

SELECT * FROM Versions
WHERE VersionId ='00000000-0000-0000-0000-000000000000'

Project Server 2010 Version Table

To find the binary version information you must see the KB article associated with each update.