From Ms project or project server I am trying to get a report on status managers on tasks. 

is there a way I can get status managers listed on the tasks in a report other than Opening all projects individually?

Hi,

in Project Server 2010 the Status Manager Information is stored in the ProjectServer_Published DB. But for reporting you have only access to the ProjectServer_Reporting DB.

So the answer is no. You have to open each schedule.

Regards

Bernhard Fischer

Hi Bernhard,

Maybe I'm missing something but as far as I know, the status manager information is actually in the Reporting DB. [dbo.MSP_EpmTask_UserView] table in the Reporting DB contains the TaskStatusManagerUID. The making a join with the [dbo.MSP_EpmResource] with the resourceUID, it should be possible to create a report.