none
How to get Resource Allocation data from SQL tables in project server 2013 RRS feed

  • Question

  • HI,

    Can any one give me sql query for getting resource allocation vs capacity for 2 years. 


    Thank You, Kumar KSV

    Wednesday, November 25, 2015 4:24 PM

Answers

  • https://gallery.technet.microsoft.com/projectserver/Server-2010-SQL-Get-5842010f

    if this answers your question please mark as answer

    • Marked as answer by kumar ksv Friday, November 27, 2015 4:42 AM
    Wednesday, November 25, 2015 6:57 PM
  • Thank you Kbwrecker & Rod Gill,

    I found the solution here is the place where you need to set the reporting data period, as how many months data you want to see.

     

    after that you need to manually run the below timer job.

    Project Server: Resource Capacity Refresh job for Project Server Service Application

    reference : https://social.technet.microsoft.com/Forums/projectserver/en-US/4777b585-c7e6-43e5-9a5c-8e109b0cdcd4/size-of-the-mspepmresourcebydayuserview-table?forum=projectserver2010general


    Thank You, Kumar KSV

    • Marked as answer by kumar ksv Friday, November 27, 2015 4:42 AM
    Friday, November 27, 2015 4:40 AM

All replies

  • https://gallery.technet.microsoft.com/projectserver/Server-2010-SQL-Get-5842010f

    if this answers your question please mark as answer

    • Marked as answer by kumar ksv Friday, November 27, 2015 4:42 AM
    Wednesday, November 25, 2015 6:57 PM
  • To fine tune the query, download the Project SDK from MSDN, it has a full schema for the reporting db.


    Rod Gill
    Author of the one and only Project VBA Book
    www.project-systems.co.nz

    Wednesday, November 25, 2015 7:26 PM
    Moderator
  • Thank you Kbwrecker

    i tryed this already i am getting only last 3 and future 3 months total 6 months data, i need last 1year and future 1 year data.


    Thank You, Kumar KSV

    Thursday, November 26, 2015 4:13 AM
  • Thank you Kbwrecker & Rod Gill,

    I found the solution here is the place where you need to set the reporting data period, as how many months data you want to see.

     

    after that you need to manually run the below timer job.

    Project Server: Resource Capacity Refresh job for Project Server Service Application

    reference : https://social.technet.microsoft.com/Forums/projectserver/en-US/4777b585-c7e6-43e5-9a5c-8e109b0cdcd4/size-of-the-mspepmresourcebydayuserview-table?forum=projectserver2010general


    Thank You, Kumar KSV

    • Marked as answer by kumar ksv Friday, November 27, 2015 4:42 AM
    Friday, November 27, 2015 4:40 AM