Project Server Statistics


Do you ever need to do an audit of your Project Server 2007 data (prior to a migration, to cleanup unnecessary data, to track the historical volume of data...)?


Please find attached a T-SQL script that will retrieve the following information:


General Project statistics (number of projects, number of resources...)


MWSnap063 2008-01-07, 22_28_31


Custom Fields and Lookup Tables statistics:


MWSnap064 2008-01-07, 22_30_17


Detail Project statistics (useful to pull into a spreadsheet to further analyze project inventory, it includes the last time it got saved, published ...etc)


MWSnap066 2008-01-07, 22_31_19


The attached script will need to be executed directly against the Published database.

EPM2007 Statistics.txt

Skip to main content