Christophe Fiessinger's Blog
Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings

  • Christophe Fiessinger's Blog

    How to extract and view Timesheet Audit Data?

    In EPM 2007 you have the ability to audit all timesheet transactions using the following flag:

    Server Settings >Time and Task Management > Settings and Defaults > Enable Timesheet Auditing

    Once audit has been activated, all timesheet changes get recorded in the following table in the Published database: MSP_TIMESHEET_ACTUAL_AUDIT

    Since the data is not in the Reporting db, I’ve created a query that uses data from both the Published and Reporting DB to extract and view timesheet audit data:

         DECLARE @DBNAME NVARCHAR(50)

         DECLARE @CMD NVARCHAR(4000)

         SET @DBNAME = REPLACE(DB_NAME(),'_Reporting','')

     

         SET @CMD=

         'SELECT       TSR.ResourceName AS ''Resource'',

                      TS_ACT_AUD_SEQUENCE ''Audit Sequence'',

                      TaskName AS ''Task'',

                      CONVERT(Decimal(9,2), TS_ACT_AUD_DELTA_VALUE/60000) AS ''Delta Value'',

                      TS_ACT_START_DATE ''Start'',

                      TS_ACT_FINISH_DATE ''Finish'',

                      MOD_DATE ''Modified'',

                      TSS.Description AS Status

                     

         FROM '+@DBNAME+'_Published.dbo.MSP_TIMESHEET_ACTUAL_AUDIT AS TSAA

         INNER JOIN MSP_TimesheetLine AS TSL

         ON TSAA.TS_LINE_UID=TSL.TimesheetLineUID

         INNER JOIN MSP_TimesheetTask AS TST

         ON TST.TaskNameUID=TSL.TaskNameUID

         INNER JOIN MSP_Timesheet AS TS

         ON TS.TimesheetUID=TSL.TimesheetUID

         INNER JOIN MSP_TimesheetResource AS TSR

         ON TSR.ResourceNameUID=TS.OwnerResourceNameUID

         INNER JOIN MSP_TimesheetStatus AS TSS

         ON TSS.TimesheetStatusID=TS.TimesheetStatusID

         ORDER BY ResourceName, TSAA.TS_ACT_AUD_SEQUENCE'

     

         EXEC (@CMD)

     

    A sample SQL Server Reporting Services report looks like this (RDL attached below):

    Timesheet Audit Data

     

    To enforce the EPM security model I recommend you write a PSI extension.

  • Christophe Fiessinger's Blog

    See You All at the Microsoft Office Project Conference!

    The Project Conference in Seattle is three weeks away.

    I’m sure you have all registered! If not do so since we have great content lined up

    I’ll also be in Madrid for the EMEA Project Conference in December.

    Safe Travel.

  • Christophe Fiessinger's Blog

    EPM & SharePoint Performance Counters

    Following Joel Oleson’s blog post on SharePoint performance counters please find below a list of EPM performance counters.

    I’m sure you are all already monitoring these in your production environment!

    Front End Perf Counters

    Back End (SQL Server) Performance Counters

    Object

    Counter

    Object

    Counter

    ASP.NET

    Application Restarts

    Processor(_Total)

    % Processor Time

    ASP.NET

    Request Execution Time

     

     

    ASP.NET

    Request Wait Time

    Memory

    Pages/sec

    ASP.NET

    Requests Queued

     

     

    ASP.NET

    Requests Rejected

    PhysicalDisk(_Total)

    Current Disk Queue Length

    ASP.NET

    Worker Process Restarts

    PhysicalDisk(_Total)

    Disk Read Bytes/sec

     

    PhysicalDisk(_Total)

    Disk Write Bytes/sec

    Memory

    Available Bytes

     

     

    Memory

    Pages/sec

    Process(sqlservr)

    % Processor Time

    Memory

    Pages/sec

    Process(sqlservr)

    Private Bytes

     

    Process(sqlservr)

    Working Set

    Process(LSASS)

    % Processor Time

     

     

    Process(OWSTIMER)

    % Processor Time

    SQLServer:Databases

    Transactions/sec

    Process(OWSTIMER)

    % Processor Time

    SQLServer:General Statistics

    User Connections

     

    SQLServer:Locks(_Total)

    Lock Wait Time (ms)

    Process(w3wp)

    % Processor Time

    SQLServer:Locks(_Total)

    Lock Waits/sec

    Process(w3wp)

    Page Faults/sec

    SQLServer:Locks(_Total)

    Number of Deadlocks/sec

    Process(w3wp)

    Page File Bytes

    SQLServer:SQL Statistics

    Batch Requests/sec

    Process(w3wp)

    Page File Bytes Peak

     

     

    Process(w3wp)

    Private Bytes

    System

    Context Switches/sec

    Process(w3wp)

    Private Bytes

     

     

    Process(w3wp)

    Virtual Bytes

     

     

    Process(w3wp)

    Virtual Bytes Peak

     

     

    Process(w3wp)

    Working Set

     

     

    Process(w3wp)

    Working Set

     

     

    Process(w3wp)

    Working Set Peak

     

     

     

     

     

    Processor(_Total)

    % Processor Time

     

     

     

     

     

    System

    Context Switches/sec

     

     

     

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

    ProjectServer:QueueGeneral

    ProjectServer:QueueJobs

    % Sql Retries / Day

    % Jobs Failed / Day

    % Sql Retries / Hour

    % Jobs Failed / Hour

    Active Job Processing Threads

    % Jobs Retried / Day

    Average Unprocessed Jobs / Day

    % Jobs Retried / Hour

    Current Unprocessed Jobs

    Average Processing Time / Day

    New Jobs / Minute

    Average Processing Time / Minute

    Sql Calls / Hour/Day

    Average Wait Time / Day

    Sql Calls / Minute

    Average Wait Time / Minute

    Sql Retries / Minute

    Jobs Failed / Minute

     

    Jobs Processed / Hour/Day

     

    Jobs Processed / Minute

     

    Jobs Retried / Minute

     

     

    ProjectServer:Winproj

    ProjectServer:User Activity

    Average time taken for Project Open

    PSI Calls per Second

    Percentage of incremental save to full save

     

    Winproj full open count in the last hour

     

    Winproj full save count in the last hour

     

    Winproj incremental open count in the last hour

     

    Winproj incremental save count in the last hour

     

  • Christophe Fiessinger's Blog

    New EPM University Courses for Partners and Customers

    http://www.msepmu.com

    Microsoft Enterprise Project Management (EPM) University is pleased to offer online courses designed to impart the required knowledge to successfully install, configure and deploy Office EPM Solution.

    Microsoft EPM University provides students with an exciting online training environment. You will benefit by

    Interacting with instructors who are happy to share their real life deployment experiences

    Developing your understanding of Office EPM Solution through the hands on Virtual Lab environment

    Reinforcing your learning through self paced labs

    Microsoft EPM University provides a cost effective training environment by bringing the classroom to you, eliminating the need for training facilities and travel expenses.  All you need is a high speed internet connection, a PC and a telephone and you’re ready to attend from the comfort of your home or office.

    New courses are:

    §  IT Professional – Technical Implementation and Configuration of

    o    Office Project Server 2007

    §  Admin Professional – Functional Implementation and Configuration

    o    of Office Project Server 2007

    §  Office Project Server 2007 Developer Training

    §  Deploying Office Project Portfolio Server 2007

  • Christophe Fiessinger's Blog

    Controlling the project workspaces list

    By default when provision a Project Web Access site, the home page contains a webbox called “Project Workspaces” which display a list of all project’s WS that have been created. By default there are two ways to display the list of WS: “All Workspaces” and “Owned Workspaces” and that’s it. A common request from customers is to display the list of WS based on a Project’s custom field so that only “active” projects are listed for instance.

    A quick and easy solution to address that need would be to create a SQL Server Reporting Services (SSRS) report and integrate that report using the SSRS standard SharePoint webpart as shown below:

    Project WS

    Please note that the list contains hyperlink similar to the standard WS webpart and that EPM user rights are not taken into account unlike the standard webpart does.

    Feel free to download the SSRS RDL below and modify it to your needs

  • Christophe Fiessinger's Blog

    How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0

    It’s all explained in this official MS knowledge base article: http://support.microsoft.com/kb/934838/en-us

  • Christophe Fiessinger's Blog

    PerformancePoint Server 2007 is RTM!

    Yes the other PPS (not Project Portfolio Server J) has just been released. PerformancePoint Server could be a great addition to an EPM deployment if you need dash boarding capabilities for instance. For more information on the product or to download a trial version please refer to: http://www.microsoft.com/business/performancepoint/

  • Christophe Fiessinger's Blog

    New Section in the EPM SDK: Visual How Tos

    Quoting Jim Corbin who is in charge of the EPM SDK: “The online Project SDK now has “Visual How Tos” section, with the first video for Project:  Creating Custom Web Parts for Project Server 2007.

    The video, in 11 minutes, provides an overview of building  a Web Part using Visual Studio and adding the Web Part to Project Web Access.

    The video is based on the simplified “No PWA Reference” code of the SDK article Walkthrough: Creating a Custom Project Server Web Part. While the original SDK article uses only C#, the video shows the Visual Basic code. The article that accompanies the video uses both Visual Basic and C#."

  • Christophe Fiessinger's Blog

    EPMsync tool between Project Server and Portfolio Server has been released on CodePlex

    “Microsoft Office Project Server 2007 (Project Server) and Microsoft Office Project Portfolio Server 2007 (Portfolio Server) integrate via the Portfolio Server gateway. Data is exchanged by running either an import or an export from Portfolio Server. But this exchange is done in bulk and typically batched. There is a desire to have a more granular experience in near real-time. The EPMSync Solution Accelerator is a proposed solution to this problem. The EPMSync Solution Accelerator synchronizes Portfolio Server attributes with Project Server custom fields (and a set of project level built-in fields). The solution is made up of a Windows Service and a number of supporting applications.”

    http://www.codeplex.com/EPMSync

  • Christophe Fiessinger's Blog

    Project 2003 Service Pack 3

    It's now available and ready for download:

    http://www.microsoft.com/downloads/details.aspx?FamilyId=FCC0627B-2C58-4A70-B808-4D7A1B26535E&displaylang=en

Page 64 of 69 (689 items) «6263646566»