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