MSP_VIEW_PROJ_ASSN_TP_BY_DAY In Project server 2013 RRS feed

  • Question

  • Hi, 

    Im develoment a sql  to obtein the remaining avialability  for local resource. 

    In the forums and loking in google i found the RA i can obtein from MSP_VIEW_PROJ_ASSN_TP_BY_DAY but in project 2013 i cant found that table or view.

    If someone can help me which is the view or table have that information. 

    Or how i can get the capacity from local resources.


    • Edited by Vgv Cruz Wednesday, October 5, 2016 5:01 PM
    Wednesday, October 5, 2016 4:37 PM

All replies

  • Have you downloaded the Project 2013 SDK from msdn? The answer is in the reporting db schema that comes with the SDK.

    Lots of useful stuff in it.

    Rod Gill
    Author of the one and only Project VBA Book and VBA developer.

    Thursday, October 6, 2016 1:40 AM
  • Hi, Yes i look there.

    The tables and views are for the enterprise resources, for local resources cant foun the table have the capacity or remaining avialability.

    Thursday, October 6, 2016 1:38 PM