Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Users Table name in project server 2010 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
     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

  • Question
    Sign in to vote
    0
    Sign in to vote
     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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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