[Building Sakai] Logged in User

[Jean-Francois Leveque]

If you have SAKAI_EVENT, look for SAKAI_SESSION. It's been there for a 
long time, it think it might have been there from the beginning.

If it's really missing, either you didn't install CLE properly or 
there's a huge issue.

Cheers,
J-F

On 20/02/2013 14:46, Nguni Phakela wrote:
> 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 <mailto: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 <mailto: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 list
>>>         sakai-dev at collab.sakaiproject.org  <mailto:sakai-dev at collab.sakaiproject.org>
>>>         http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>>         TO UNSUBSCRIBE: send email tosakai-dev-unsubscribe at collab.sakaiproject.org  <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org>  with a subject of"unsubscribe"
>>
>>         --
>>
>>         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 <mailto:miguel.carro at samoo.es>
>>
>>         +34 - 673 80 32 69 <tel:%2B34%20-%20673%2080%2032%2069>
>>
>>         Skype: mcpellicer
>>
>>         www.samoo.es <http://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
>
>     --
>
>     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 <mailto:miguel.carro at samoo.es>
>
>     +34 - 673 80 32 69 <tel:%2B34%20-%20673%2080%2032%2069>
>
>     Skype: mcpellicer
>
>     www.samoo.es <http://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