none
Tracking project Pro 2013 users RRS feed

  • Question

  • Is there any way that you can tell who has been connecting to Project Server 2013 using Project Pro 2013?

    Mike Tichenor

    Friday, August 21, 2015 2:23 PM

Answers

  • Hi Mike,

    Basically, I'd build a report merging 2 types of data:

    The last connection for users, so you'll know the active users for a certain period (last year, last month). You can have this info from the server settings, then manage users. You can also query the published DB, something like:

    SELECT RES_NAME, WRES_LAST_CONNECT_DATE, RES_LAST_ACTIVITY
    FROM MSP_RESOURCES

    Then you could filter the list of users on the ones having the permission to connect to Project Server with MS Project Pro (Log on to Project Server from Project Professional). Here is a script which might help.

    The combination of both output should tell you who has been connecting to Project Server using Project Pro on a specific period.

    Also refer to this article for a predefined report with the query (for PS2010):

    http://blogs.msdn.com/b/wwepmcoe/archive/2010/01/19/how-to-determine-resource-licensing.aspx


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, August 21, 2015 2:55 PM
    Moderator

All replies

  • Hi Mike,

    Basically, I'd build a report merging 2 types of data:

    The last connection for users, so you'll know the active users for a certain period (last year, last month). You can have this info from the server settings, then manage users. You can also query the published DB, something like:

    SELECT RES_NAME, WRES_LAST_CONNECT_DATE, RES_LAST_ACTIVITY
    FROM MSP_RESOURCES

    Then you could filter the list of users on the ones having the permission to connect to Project Server with MS Project Pro (Log on to Project Server from Project Professional). Here is a script which might help.

    The combination of both output should tell you who has been connecting to Project Server using Project Pro on a specific period.

    Also refer to this article for a predefined report with the query (for PS2010):

    http://blogs.msdn.com/b/wwepmcoe/archive/2010/01/19/how-to-determine-resource-licensing.aspx


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, August 21, 2015 2:55 PM
    Moderator
  • Thx for the info

    Mike Tichenor

    Tuesday, August 25, 2015 6:31 PM