Do More Than Manage
Gord Schmidt's Ideas for Doing More with Microsoft Project Server
Summary Task

Enterprise Calendars used by Enterprise Projects

The following SQL query can be run against the Project Server Published database to get a list of Enterprise Calendars used by Enterprise Projects in Project Server 2007.

select distinct
      p.proj_name,
      bc.cal_name
from
      msp_projects p
      join msp_project_calendars pc on pc.proj_uid = p.proj_uid
      join msp_calendars bc on bc.cal_uid = pc.cal_base_uid
where
      pc.cal_base_uid is not null
 

Posted by Gord Schmidt on Sunday, October 11, 2009 | Permalink | Extend

Milestone