[Building Sakai] Description of table SAKAI_EVENT

[Steve Swinsburg]

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/1520bd48/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/1520bd48/attachment.bin