user access logging

E

Elizabeth

Hi there,

Quick thanks for all help received so far. We would like to generate a log
of user access so that I can record growth inthe use of Project Server. Is
there a way that we can generate a daily report with details of username,
date and time of access.
Kind Regards
Elizabeth C
 
N

NateSaber

If you want to log users who connect to the PWA or connect to the Project
Server through Project Pro. 2003, there are a few ways you could do this:

1. Log into the PWA web site. Click on Admin. Click Manage Users and Groups.
Click Show Grid. Click Export Grid to Excel.
This method would work because it display the user name and when the last
connected. However, you would have to do this everyday.

2. Create a SQL Job on the SQL Server which holds the ProjectServer
Database. The job will be based off a Stored Procedure or Query which will
Select Res_Name, wres_last_connected from MSP_Web_Resources table, this is a
simple SQL statement which will gather the User Name and their Last
Connection from the resource pool. Create the job to run everyday, save the
sata to a file, and then notify/send the data someone. If you have a DBA or
someone proficient in SQL they can easily do this for you.

I hope this helps.
 
Top