none
Where "Personal Tasks" saved in database ? RRS feed

  • Question

  • Hi, 

    I want to extract Personal Tasks of user from database. Kindly let me know from which database i.e. Published, Reporting, Tables or Views I can get this information.

    Regards,

    Mehar

    Wednesday, September 26, 2012 5:57 PM

Answers

  • Should be in the TimesheetLines user view in the Reporting database.

    Treb Gatte | @tgatte | http://AboutMSProject.com

    Saturday, September 29, 2012 9:52 PM
    Moderator
  • Agreed with Treb. To give your more details, These personal tasks are stored with ProjectName as Personal Tasks. So if you run sample query in reporting database, you can see the personal tasks with Resource & timesheet data.

    SELECT [PeriodName]
          ,[PeriodUID]
          ,[PeriodStatus]
          ,[PeriodStatusID]
          ,[TimesheetName]
          ,[ResourceName]
          ,[ResourceUID]
          ,[ProjectName]
          ,[ProjectUID]
          ,[TaskName]
            FROM [MSP_TimesheetLine_UserView]
            Where ProjectName = N'Personal Tasks'

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, October 3, 2012 5:30 AM

All replies

  • Should be in the TimesheetLines user view in the Reporting database.

    Treb Gatte | @tgatte | http://AboutMSProject.com

    Saturday, September 29, 2012 9:52 PM
    Moderator
  • Agreed with Treb. To give your more details, These personal tasks are stored with ProjectName as Personal Tasks. So if you run sample query in reporting database, you can see the personal tasks with Resource & timesheet data.

    SELECT [PeriodName]
          ,[PeriodUID]
          ,[PeriodStatus]
          ,[PeriodStatusID]
          ,[TimesheetName]
          ,[ResourceName]
          ,[ResourceUID]
          ,[ProjectName]
          ,[ProjectUID]
          ,[TaskName]
            FROM [MSP_TimesheetLine_UserView]
            Where ProjectName = N'Personal Tasks'

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, October 3, 2012 5:30 AM