none
Timesheet hours by day RRS feed

  • Question

  • Hi,

      Can anyone share / advice query to extract timesheet actuals by day.


    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Saturday, May 2, 2015 8:15 AM

Answers

  • Hi,

    are you looking for an SQl query? Then this might help:

    SELECT        TSL.ResourceName
    			, TSL.ProjectName
    			, TSL.TaskName
    			, TSL.PeriodName
    			, TSL.PeriodStartDate
    			, TSA.TimeByDay
    			, TSA.ActualWorkBillable
    FROM            dbo.MSP_TimesheetLine_UserView AS TSL 
    	INNER JOIN  dbo.MSP_TimesheetActual_OlapView AS TSA 
    		ON TSL.TimesheetLineUID = TSA.TimesheetLineUID
    WHERE        (TSA.ActualWorkBillable <> 0)

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    Saturday, May 2, 2015 9:33 AM
    Moderator

All replies

  • Hi,

    are you looking for an SQl query? Then this might help:

    SELECT        TSL.ResourceName
    			, TSL.ProjectName
    			, TSL.TaskName
    			, TSL.PeriodName
    			, TSL.PeriodStartDate
    			, TSA.TimeByDay
    			, TSA.ActualWorkBillable
    FROM            dbo.MSP_TimesheetLine_UserView AS TSL 
    	INNER JOIN  dbo.MSP_TimesheetActual_OlapView AS TSA 
    		ON TSL.TimesheetLineUID = TSA.TimesheetLineUID
    WHERE        (TSA.ActualWorkBillable <> 0)

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    Saturday, May 2, 2015 9:33 AM
    Moderator
  • Thanks Barbara.

    Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS

    Saturday, May 2, 2015 4:29 PM