[Building Sakai] Description of table SAKAI_EVENT

[Luiz Antonio Falaguasta Barbosa]

Thanks Steve!

I'm interpreting your  explanation and trying to write an SQL for this, but
if you have one ready there, I'll appreciate to see it. :-)

Luiz

2009/3/10 Steve Swinsburg <s.swinsburg at lancaster.ac.uk>

> Hi Luiz,
> you can match the SESSION_ID in the SAKAI_EVENT table to the user that
> created the event by joining with the SAKAI_SESSION table and getting the
> SESSION_USER value. That will be a Sakai internal userid which you can then
> get an EID from by joining the SAKAI_USER_ID_MAP table.
>
> If you get stuck let us know and we can post some example SQL.
>
>
> cheers,
> Steve
>
> ---
> Steve Swinsburg
> Portal Systems Developer
> Centre for e-Science
> Lancaster University
> Lancaster
> LA1 4YT
>
> email: s.swinsburg at lancaster.ac.uk
> phone: +44 (0) 1524 594870
>
>
>
>
>
>
>
> On 10 Mar 2009, at 14:09, Luiz Antonio Falaguasta Barbosa wrote:
>
> Fine! Thank you very much, guys!
>
> Now, please, again about session_id field in SAKAI_EVENT... into the values
> for this field, is there any substring that identify the user in that
> session?
>
> Thanks in advance!
>
> Luiz
>
> 2009/3/10 Steve Swinsburg <s.swinsburg at lancaster.ac.uk>
>
>> Ah yeah looks like it's related to maintenance. Most are happening on
>> startup and when recreating the portfolioAdmin site et al. Nice one.
>>
>>
>> cheers,
>> Steve
>>
>> ---
>> Steve Swinsburg
>> Portal Systems Developer
>> Centre for e-Science
>> Lancaster University
>> Lancaster
>> LA1 4YT
>>
>> email: s.swinsburg at lancaster.ac.uk
>> phone: +44 (0) 1524 594870
>>
>>
>>
>>
>>
>>
>>
>> On 10 Mar 2009, at 14:00, Matthew Buckett wrote:
>>
>>  On Tue, Mar 10, 2009 at 1:52 PM, Steve Swinsburg
>>> <s.swinsburg at lancaster.ac.uk> wrote:
>>>
>>>> The ~localhost~admin in the SESSION_ID field I'm not sure of. Presume
>>>> it's
>>>> events being triggered by the admin user. Seems inconsistent though.
>>>>
>>>
>>> Could be a quartz job (Admin Workspace -> Job Scheduler), which sets
>>> it's own session ID I think or possibly one of the threads spawned at
>>> startup that does maintenance.
>>>
>>> --
>>>  Matthew Buckett
>>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/28d53b75/attachment.html