[Building Sakai] Description of table SAKAI_EVENT

[Steve Swinsburg]

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/3755325b/attachment-0001.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/3755325b/attachment-0001.bin