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

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

> 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
> 

tried that but did not find anything reagarding global template. 

"Andrew Lavinsky" wrote:

> 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
> 
> > 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
> > 
> 
> 
> .
> 

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:
> tried that but did not find anything reagarding global template.
>
> "Andrew Lavinsky" wrote:
>
>> 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
>>
>>> 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
>>>
>>
>>
>> .
>>