#ProjectServer data snapshot for reporting #PS2010 #MSProject #SP2010 #Excel #SSRS #SQL

Quite often there is a requirement for some form of data snapshot in Project Server for trend analysis reporting. This post will give a simple explanation of how this can be achieved using the Project Server Reporting database and a SQL job. This example just captures some key project metrics such as Actual Work, Actual...

#ProjectServer and #SharePoint 2010 April 2012 Cumulative Update #PS2010 #SP2010 #MSProject

The Office 2010 April 2012 Cumulative Updates are now available, please see the links below: http://support.microsoft.com/kb/2685449 Project Server 2010 Server Roll up package April 2012 CU (Recommended): http://support.microsoft.com/kb/2598152   Project Server 2010 April 2012 CU (Included in the Server Roll up package): http://support.microsoft.com/kb/2598272 Project 2010 April 2012 CU: http://support.microsoft.com/kb/2598274   As always, test these updates...

#ProjectServer 2010 views export to #Excel AutoSum #PS2010 #MSProject

While on client site recently a query was raised regarding using the AutoSum function in Excel for the exported Resource Availability view, this didn’t work due to the hours containing an h. For the AutoSum functionality to work only numeric characters can be in the range. There is a very quick and simple method to...

Check server times for #SharePoint / #ProjectServer farms #PS2010 #SP2010 #MSProject #PowerShell

For a server farm it is important that all server times are in sync, for Project Server this is key. For example if the Application server has a different time to the SQL server you might see jobs in the Project Server queue that are in sleeping state. A useful PowerShell script to check all...

#ProjectServer 2010 environment rollover steps #PowerShell #PS2010 #MSProject #SP2010

This blog post will detail the PowerShell commands required to carry out an environment rollover using Windows PowerShell where possible. The steps below use the 5 database approach to rollover over the Production environment to the Test / Development environment. For more details on the Project Server database restore please see Andrew’s blog posts found...