locked
Users Table name in project server 2010 RRS feed

  • Question

  • Hi everybody

    someone know how can find the table that contain the users of projectserver 2010 in SQL ?

    which one is the data Base name ?

    which one is the table name ?

    Thanks


    Alejandro Tabares Florez

    Wednesday, October 10, 2012 4:14 PM

Answers

  •  Hi

    Alejandro,

    You can find resource information from Project Server Reporting database

    Select [ResourceName] from [MSP_EpmResource_userview]

    You can find detailed reporting schema by downloading Project Server 2010 SDK

    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    File : Project2010_ReportingDB.chm


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.




    Wednesday, October 10, 2012 5:58 PM

All replies

  •  Hi

    Alejandro,

    You can find resource information from Project Server Reporting database

    Select [ResourceName] from [MSP_EpmResource_userview]

    You can find detailed reporting schema by downloading Project Server 2010 SDK

    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    File : Project2010_ReportingDB.chm


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.




    Wednesday, October 10, 2012 5:58 PM
  • HI Hrishi thanks again for your help, as always your answers help me to much.

    Alejandro Tabares Florez

    Thursday, October 11, 2012 12:19 PM