PS 2003 Tracking Users

[Bryan]

Is there a way to verify who has opened projects?
I have a user that captured a screen shot of the "checked out" message
showing another user having his project checked out. When I went in to check
in the project for him that user was not listed as having any projects
checked out (I am the admin). This has started some concern about the
security of Project Server 2003.

 

[Gagan Goel - MCP PMP]

Bryan,

Out of the box you do not have much more options than seeing the checkout by
or last saved by or last modified fields. Without custom coding there is no
mechanism to see historical records on who opened before the last modified

If you are using Windows authentication and even with out of box security
configuration Project server is good about security. So do not panic on
unauthorized access. Sometimes there are rogue sessions which can create a
corrupt checked out state which does not show up in admin menu.

You can File Save as a new project and delete the original one to see if
that helps.

Hope this helps.

Gagan

 

[Chak]

Hello Bryan,

There is no such mechanism like log or event queue to find out the
history of the updates. Alternatively, I can suggest the following SQL
query. You can run this query against your project server database.

SELECT PROJ_ID, PROJ_NAME, PROJ_LAST_SAVED, PROJ_LOCKED,
PROJ_MACHINE_ID,
PROJ_CHECKEDOUT, PROJ_CHECKOUTBY,
PROJ_CHECKOUTDATE
FROM MSP_PROJECTS
ORDER BY PROJ_NAME


If Project plan has been checkedout by the user, you will see value 1
on PROJ_CHECKEDOUT

If Project plan has been locked, you will see value 1 on PROJ_LOCKED

Also you can verify the PROJ_MACHINE_ID value, most of the time it
contains the user machine name. So, it's kind of quality check for you
to get the clue about who was working last time on project plan.

Thanks
Chak
http://www.epmcentral.com

 

[Gary L. Chefetz [MVP]]

Bryan:

For a complete rundown on resolving this issue see:

http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/checkinprojectsandresources.aspx


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com