[Building Sakai] Description of table SAKAI_EVENT

[Luiz Antonio Falaguasta Barbosa]

Fine Steve! Thanks!

Luiz

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

> Ok heres some verbose SQL joining all three tables:
> select
> se.EVENT_ID,
> se.EVENT_DATE,
> se.EVENT,
> map.EID
>  from
> SAKAI_EVENT se,
> SAKAI_SESSION ss,
> SAKAI_USER_ID_MAP map
>  where
> se.EVENT_ID=4039
> and
> se.SESSION_ID=ss.SESSION_ID
> and
>  ss.SESSION_USER=map.USER_ID
>
>
> which gives me the id, the date, the event and who did it. You can
> customise this to your heart's content ;)
>
>
>
>
> 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:30, Luiz Antonio Falaguasta Barbosa wrote:
>
> 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/e28984a0/attachment.html