Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.