Last Login Timestamp

[MSPLearner]

I want to find out the last time a user logged into PWA. Is this information
available on the Reporting or other DB?

MSPLearner

 

[Jonathan Sofer [MVP]]

You can view the last connect column under PWA>Server Settings>Manage Users

You can also get this data from the Published database

SELECT RES_NAME, WRES_LAST_CONNECT_DATE, RES_LAST_ACTIVITY
FROM MSP_RESOURCES

WRES_LAST_CONNECT_DATE is a date time stamp of when the user last initiated
a logon to the environment PWA or Project Pro will initiate a new timestamp
here. This is the same date as what you see under the last connect column
under PWA>Server Settings>Manage Users

RES_LAST_ACTIVITY is a date time stamp of when the user last clicked on a
page in PWA or an activity in Project Pro that hits the database.

Disclaimer: Microsoft does not support querying the Published database.

Hope this helps,

Jonathan Sofer

 

[MSPLearner]

Janathan,

Thank you. This answers my question. And I fully understand your disclaimer.

MSPLearner

 

[MSPLearner]

Jonathan,

This just peaked my curiosity further.

Under Server Settings/About Project Server where does the user count come
from.
I am especially interested the Project Pro counts.

Number of Active Project Server Users: xxx

Number of Project Professional Users: xxx

MSPLearner

 

[Jonathan Sofer [MVP]]

There is a short description on that page that explains it.

"The number of Project Server users is calculated by counting the number of
active Project Server user accounts that have permissions to log on. The
number of Project Professional users is calculated by counting the number of
active Project Server users accounts that have permissions to log on as well
as the permission 'Log on to Project Server from Project Professional'."

Hope that helps,

Jonathan

 

[MSPLearner]

I should have been more clear. I am interested in finding where on the DB I
can locate the

"permission to 'Log on to Project Server from Project Professional'.".

MSPLearner