Project Server 2007 - Ent Global Template Log

[Hadi]

Experts,

In Project Server 2007, is there a way that i can lookup a log for when and
who opened and saved the enterprise template? I am in the Admin along with
another two folks. One of them does not really know what he's doing (I know
you gonna ask me what business he has being an Admin; we'll that's another
issue I'm dealing with). I think he opened the template and applied the
reosource sheet view, and then saved the template. so he corrupted it and i'm
trying to find a log of that.

thanks,

Hadi

 

[Andrew Lavinsky]

You might be able to pull that data out of the queue, depending on how long
you retain data in there. Go into Manage Queue and see if you can play with
the settings to get what you need.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Hadi]

tried that but did not find anything reagarding global template.

 

[Barbara - Austria]

Hi Hadi,

seems that it happened too long ago.

You can try in Published DB, but only the very last modification is
saved there:
SELECT PROJ_NAME, PROJ_LAST_SAVED, PROJ_SESSION_DESCRIPTION
FROM dbo.MSP_PROJECTS
WHERE (PROJ_NAME = N'eglobal')
I am not sure if PROJ_SESSION_DESCRIPTION is showing client name, it was
the only information I could find and was correct in my case.

Since you write that your template is corrupted ... One idea: Is SP2
applied without CU August or later? If that is the case move on reading.
You ran into an issue of SP2 described perfectly on Gary's blog:
http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=69
He also described how to solve on
http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=58 (even if
the title describes another appearance caused by a corrupted Enterprise
Global). Make sure that you apply CU August or later before re-opening
EGlobal or even before repairing. If you have modified Standard
calendar: Make an administraive backup of calendars before repairing
EGlobal and restore when you are finished (eglobal.sql will also reset
calendars).

Regards
Barbara

Am 07.04.2010 02:56, schrieb Hadi: