EndUser Project Server 2007 Training


Many people have sent me emails and contacted me for Project Server 2007 End User Training videos but unfortunately I have not seen any Project Server step by step training videos.  I am some how thinking about starting Project Server 2007 End User Training Videos screencasts.  I am not sure whether I will be able to do it or not but I will try as much as I can.  I think one small session per day will not hurt me 🙂

I am hopeful that I will start the session from tomorrow.  I have EPM 2007 VPC which includes Project Server 2007, Portfolio Server, Microsoft Project 2007 and Microsoft Office 2007 etc .  I will surly use it. 

I also have to compile the list of session that will be in this training.  If you have any comments to want to add a session please drop a comment below.  I will try to make a session for this.

Regards,

Jerry

Installing MOSS on Windows Server 2008 VPC Part III


This is part III of the series.  In this post I will provide the steps to install MOSS on Windows Server 2008 by Splitstream.

When I ran the MOSS Setup I got the following message.

image

Windows Server 2008 does not support MOSS without SP1.  Either you can download the SP1 Version of MOSS or you can make splitstream easily.  Follow the steps given below.

1. Get both Service Pack 1 of MOSS and WSS 3.0 and rename the files to some easy names. Open the command prompt and navigate to the location.  In my case files on placed on desktop
image imageimage
image image
MOSS SP1  
Create a folder in C Drive name SplitStreams Run the following command to extract the files  the folder
image image 
filename.exe /extract:C:\SplitStreams
MOSS Sp1 Setup will run Accept the agreement and click contineue
image image
Wait for the extraction  
image  
WSS SP1  
Go to command prompt again run the command with WSS 3.0 SP1 File. accept and Contineue
image image
Wait for the extraction navigate to the Extracted Folder C:\SplitStreams in my case
image

clip_image001

Press Control + A or Select All Files and Press Control C to copy all files Go to MOSS Installation Folder and copy the files to Updates folder

clip_image001[5]

Screen clipping taken: 6/30/2008, 8:53 PM

image
The folder will look like this  
image Run MOSS Setup now and configure as usual.  If you don’t know how to install MOSS see the guide in the files section or link in the my best posts.
MOSS Installation Guide – Step by Step
Installing Project Server 2007 on the same VPC  
Go to Project Server Installation folder and copy all the files from Splitstream folder to that Updates folder  
Run project Server setup and then run the configuration wizard.  
   

Project Server 2007 Certification


I was looking at the preparation guide of Microsoft Project Server 2007 exam (70-633) and was shocked to see that I have never looked at it carefully.   Why because I have a good experience of working in project server 2003 and project server 2007 environments which covers all aspects of the exam. 

  • Skills measured by Exam 70-633
    • Initiating Projects
    • Save Microsoft Office Project Professional projects.
    • Create proposals.
    • Create activity plans.
    • Build a resource plan.
  • Planning Projects
    • Plan scope and cost.
    • Plan time.
    • Plan resources.
    • Manage resource capacity.
    • Create a risk item.
  • Executing Projects
    • Match and replace resources.
    • Build Project Team with named resources.
    • Distribute information to project stakeholders.
    • Create a timesheet.
    • Manage timesheets.
    • Review and approve a timesheet.
  • Monitoring and Controlling Projects
    • Enter task updates.
    • Manage status reports.
    • Report data by using PWA.
    • Manage issues and risks.
    • Manage deliverables.
  • Managing Project Professional and PWA Environments
    • Access Project Center.
    • Log on to PWA by using Windows Internet Explorer.
    • Authenticate Project Professional to a project server.
    • Set options.
    • Create, save, or update enterprise templates.
  • If you have worked in implementing an EPM environment or worked as EPM Expert or PMO using Project server 2007 this exam could be very easy for you.  I have good understanding of most of the topics that are listed above but I would like to do a little preparation of the Deliverables, Resource Plans and Managing Timesheets because they are new and a little hard to understand topics.

    Hopefully I will go for this exam this Saturday.  I am confident that I will be able to pass the exam easily.

    I am using the following books

    McGraw.Hill.Microsoft.Office.Project.Server.2007.The.Complete.Reference

    Microsoft Office Project Server 2007 Unleashed 

    The study guide for the exam is available at

    http://www.microsoft.com/learning/en/us/exams/70-633.mspx

    Regards,

    Jerry

    Microsoft Project Server 2007 Resource Kit


    Project Server 2007 resource kit is available for download.

    The Project Server 2007 Project Resource Kit tools consist of the following tools:

    • Portfolio Analyzer Views Migration: Allows an administrator to bulk edit the location of an analysis server for multiple data analysis views.
    • Project Server Settings Backup and Restore (Playbooks): Allows an administrator to backup Project Server settings and restore those settings to another Project Server.
    • Project Server Data Populator: Allows an administrator to populate Project Server with projects, resources and other objects. Useful for helping capacity and performance testing.
    • Project Workspace Site Relinker: Allows an administrator to relink the connection between Project Server and Project Workspace sites.
    • View Effective Rights: Allows an administrator to query the Project Server to determine the effective permissions of users against projects or resources.

    http://www.microsoft.com/downloads/details.aspx?FamilyId=A33D253C-6424-48E4-B87E-0861D1977BB7&displaylang=en

    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