[Building Sakai] Description of table SAKAI_EVENT

[DAVID ROLDAN MARTINEZ]

select * from sakai_event se, sakai_session ss, sakai_user_id_map suim where
      se.session_id= ss.session_id and ss.session_user=suim.user_id

Hope this helps...


De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Luiz Antonio Falaguasta Barbosa
Enviado el: martes, 10 de marzo de 2009 15:30
Para: Steve Swinsburg
CC: sakai-dev at collab.sakaiproject.org Dev
Asunto: Re: [Building Sakai] Description of table SAKAI_EVENT

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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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/c6f39ccb/attachment-0001.html