Query to Get Project Assignment Time Phased


Project Server 2003 Query to Get Project Assignments as Timephased

SELECT     dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME AS [Task Name], dbo.MSP_WEB_PROJECTS.PROJ_NAME AS Project,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart, dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork / 60000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME
FROM         dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
                      dbo.MSP_WEB_ASSIGNMENTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID AND
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_PROJECTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_RESOURCES ON dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID

 

Note: Please do test this query on local development environment before testing in on production.

Jerry

SQL Query to Get Project Resources by Role


I was developing some reports on Project Server 2003 recently, while working I got a Question.

Question : I need to get Projects, Its Resources, Resource Role in Project Server and Project Created by in a report.

The query to get this done is give below.

SELECT     MSP_PROJECTS.PROJ_NAME AS Project, MSP_WEB_RESOURCES.RES_NAME AS Resource,
                      MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME AS [Role In Project], MSP_PROJECTS.PROJ_PROP_AUTHOR AS [Project Created By]
                      –MSP_RESOURCES.PROJ_ID, MSP_RESOURCES.RES_EUID, MSP_RESOURCES.RES_UID
FROM         MSP_WEB_SECURITY_GROUP_MEMBERS INNER JOIN
                      MSP_WEB_SECURITY_GROUPS ON
                      MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID = MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID INNER JOIN
                      MSP_WEB_RESOURCES ON MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID = MSP_WEB_RESOURCES.WRES_GUID INNER JOIN
                      MSP_PROJECTS INNER JOIN
                      MSP_RESOURCES ON MSP_PROJECTS.PROJ_ID = MSP_RESOURCES.PROJ_ID ON
                      MSP_WEB_RESOURCES.RES_EUID = MSP_RESOURCES.RES_UID
WHERE     (MSP_RESOURCES.RES_UID > 0) AND (MSP_RESOURCES.RES_EUID IS NOT NULL) AND (MSP_PROJECTS.PROJ_TYPE = 0)
ORDER BY Project, Resource, [Role In Project]

 

Note: Please do test this query in local server dev before using it on production environments.

Microsoft Project 2007 – Baselines and Updating Project Progress


Saving and using Baselines

You should save the baseline when:

  • You have developed the project plan as fully as possible. (However, this does not mean that you cannot add tasks, resources, or assignments to the project after work has started, for this is often unavoidable.)

  • You have not yet started entering actual values, such as a task’s percentage of completion.

Tip 

You can set up to 11 baselines in a single plan. (The first one is called Baseline, and the rest are Baseline 1 through Baseline 10.) Saving multiple baselines can be useful for projects with exceptionally long planning phases in which you might want to compare different sets of baseline values. For example, you might want to save and compare the baseline plans every month as the planning details change. To clear a previously set baseline, click Clear Baseline on the Tools menu, Tracking submenu. To learn more about baselines in Project’s online Help, type create baseline.

Three ways to update project progress

Overall Project Progress

The simplest approach to tracking progress is to report that the actual work is proceeding exactly as planned. For example, if the first month of a five-month project has elapsed and all of its tasks have started and finished as scheduled, you can quickly record this in the Update Project dialog box.

image

Task updates using % Complete and Actual Start

After work has begun on a task, you can quickly record its progress as a percentage. When you enter a completion percentage other than 0, Project changes the task’s actual start date to match its scheduled start date. It then calculates actual duration, remaining duration, actual costs, and other values based on the percentage you enter.

image

 

Project Professional 2003 and Project Server 2003 Service Pack 3


Project Professional 2003 Service Pack 3

The new Service Pack for Project Professional is here for Project

The good news is that Project Professional 2003 can open Project Professional 2007 Files.

Project Server 2003 Service Pack 3

Project Server 2003 Service Pack 3 is now available for Download at

http://www.microsoft.com/downloads/details.aspx?FamilyId=C5269419-034F-458D-9255-DE6C9F2A6F28&displaylang=en

Issue that are fixed by project server 2003 Service pack 3

http://support.microsoft.com/kb/938796/

Jerry