[Building Sakai] Logged in User

[Nguni Phakela]

I don't see sakai_session in the database. We are using 2.8.0.

I see that SAKAI_EVENT has EVERY event that is associated with a userid.
And the table is HUGE.

Cheers,
Nguni


On Wed, Feb 20, 2013 at 3:44 PM, Miguel Carro Pellicer <
farreri.sakai at gmail.com> wrote:

>  I think that this Query/API doesn't exists, i consider it interesting
> for administration purposes.
>
> Regards, Miguel.
>
>  El 20/02/2013 14:41, Nguni Phakela escribió:
>
> Hi Miguel,
>
>  I know about the table but I was hoping there was an API/interface that
> could help me with this, instead of the direct database calls.
>
>  I am using MYSQL though.
>
>  Cheers,
>
>
> On Wed, Feb 20, 2013 at 3:39 PM, Miguel Carro Pellicer <
> farreri.sakai at gmail.com> wrote:
>
>>  Try this (Mysql Syntax, convert to Oracle if case)
>>
>> SELECT ss.session_start,sue.eid FROM sakai_session ss, sakai_user_id_map
>> sue where ss.session_user = sue.user_id and sue.eid = 'XXXXX' order by
>> session_start desc LIMIT 1;
>>
>> Where XXXXX is the userEid or login.
>>
>> Regards, Miguel.
>>
>>  El 20/02/2013 14:32, Nguni Phakela escribió:
>>
>>  Hi All,
>>
>>  How do I find the last time (date) that a user has logged into Sakai?
>>
>>  Cheers,
>>
>>  --
>> Nguni Phakela
>>
>>
>>  _______________________________________________
>> sakai-dev mailing listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>
>>
>> --
>>
>> [image: cid:image001.jpg at 01C9F98A.71C74E60] <http://www.samoo.es/>
>>
>>   <http://www.samoo.es/>
>>
>> *Miguel Carro Pellicer*
>>
>> *Technical Manager - Director técnico*
>>
>> miguel.carro at samoo.es
>>
>> +34 - 673 80 32 69 <%2B34%20-%20673%2080%2032%2069>
>>
>> Skype: mcpellicer
>>
>> www.samoo.es
>>
>>
>>
>> Este  correo  y  sus archivos asociados son privados y confidenciales y
>> va dirigido  exclusivamente  a su destinatario. Si recibe este correo sin
>> ser el  destinatario del mismo, le rogamos proceda a su eliminación y lo
>> ponga en  conocimiento del emisor. La difusión por cualquier medio del
>> contenido de  este  correo podría ser sancionada conforme a lo previsto en
>> las leyes españolas, Ley Orgánica 15/1999 de Protección de Datos de
>> Carácter Personal.  No  se autoriza la utilización con fines comerciales o
>> para su incorporación a ficheros automatizados de las direcciones del
>> emisor o del destinatario.”
>>
>>
>>
>> This mail and its attached files are confidential and are only and
>> exclusively intended to their addressee. In case you may receive this mail
>> not being its addressee, we beg you to let us know the error by reply and
>> to proceed to destroy it. The circulation by any mean of this mail could be
>> penalised in accordance with the Spanish legislation. Is not allowed the
>> use of both, the transmitter and the addressee’s, address with a commercial
>> aim, or in order to be incorporated to automated data process or to any
>> kind of files.
>>
>>
>>
>> P Antes de imprimir este correo electrónico piense bien si es necesario
>> hacerlo. El medioambiente es cosa de todos.
>>
>>
>>
>>
>>
>
>
>
>  --
> Nguni Phakela
>
>
> --
>
> [image: cid:image001.jpg at 01C9F98A.71C74E60]**** <http://www.samoo.es/>
>
> ** ** <http://www.samoo.es/>
>
> *Miguel Carro Pellicer*
>
> *Technical Manager - Director técnico*
>
> miguel.carro at samoo.es****
>
> +34 - 673 80 32 69****
>
> Skype: mcpellicer
>
> www.samoo.es****
>
> ** **
>
> Este  correo  y  sus archivos asociados son privados y confidenciales y va
> dirigido  exclusivamente  a su destinatario. Si recibe este correo sin ser
> el  destinatario del mismo, le rogamos proceda a su eliminación y lo ponga
> en  conocimiento del emisor. La difusión por cualquier medio del contenido
> de  este  correo podría ser sancionada conforme a lo previsto en las leyes
> españolas, Ley Orgánica 15/1999 de Protección de Datos de Carácter
> Personal.  No  se autoriza la utilización con fines comerciales o para su
> incorporación a ficheros automatizados de las direcciones del emisor o del
> destinatario.”****
>
> ** **
>
> This mail and its attached files are confidential and are only and
> exclusively intended to their addressee. In case you may receive this mail
> not being its addressee, we beg you to let us know the error by reply and
> to proceed to destroy it. The circulation by any mean of this mail could be
> penalised in accordance with the Spanish legislation. Is not allowed the
> use of both, the transmitter and the addressee’s, address with a commercial
> aim, or in order to be incorporated to automated data process or to any
> kind of files. ****
>
> ** **
>
> P Antes de imprimir este correo electrónico piense bien si es necesario
> hacerlo. El medioambiente es cosa de todos.****
>
> ** **
>
> ** **
>



-- 
Nguni Phakela
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130220/b9cf59d3/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3022 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130220/b9cf59d3/attachment.jpe 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3022 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130220/b9cf59d3/attachment-0001.jpe