Project Server 2010: Export Status Report Responses using Excel

ProjectServer2010 LogoMicrosoft didn’t spend too much time on the “Status Reports” module in Project Server 2010, leaving it with many disadvantages and even a somewhat not so intuitive handling. This affects especially the extraction of Responses to Status Reports – which you can only export to a non-editable Word template.

Having not found any better solution on the internet for improving the retrieval of Staus Report responses (except a scheme of the required tables), I decided to make my own SQL-Query to do so.

Continue reading

Project Server 2010: How-to add Notifications for your Users

ProjectServer2010 LogoUnfortunately Microsoft’s Project Server 2010 doesn’t allow an administrator to set default settings for Notifications for all Users. They basically would have to go into their “Personal Settings > Settings for my Alerts and Reminders” themself and set the notification settings for Tasks, Status Reports, etc.

And as we all know: the User’s won’t do it.

So I had to figure out a way how I can “force” my Users to receive certain Notifications. After various Google Search Queries I had to realize, that there is no other way than digging into the database directly (although NOT SUPPORTED BY MICROSOFT!) and add the reminders for my Users manually (if this is not true, please let me know!!).

  • Affected Database:
    • ProjectServer_Published
  • Required Tables:
    • dbo.MSP_REMINDER_SUBSCRIPTION
    • dbo.MSP_REMINDER_DEFINITION
    • dbo.MSP_RESOURCES

Step 1
Continue reading