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...)
Custom Fields and Lookup Tables statistics:
Detail Project statistics (useful to pull into a spreadsheet to further analyze project inventory, it includes the last time it got saved, published ...etc)
The attached script will need to be executed directly against the Published database.