[Building Sakai] Logged in User
Nguni Phakela
nguni52 at gmail.com
Thu Feb 21 02:06:19 PST 2013
Hi Jean-Francois,
I realized afterwards that it was in all caps. I had searched for the one
that was in small caps.
Cheers,
Nguni
On Thu, Feb 21, 2013 at 12:05 PM, Jean-Francois Leveque <
jean-francois.leveque at upmc.fr> wrote:
> 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<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<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<sakai-dev at collab.sakaiproject.org> <mailto:
>>>> sakai-dev at collab.**sakaiproject.org <sakai-dev at collab.sakaiproject.org>
>>>> >
>>>> http://collab.sakaiproject.**org/mailman/listinfo/sakai-dev<http://collab.sakaiproject.org/mailman/listinfo/sakai-dev>
>>>>
>>>> TO UNSUBSCRIBE: send email tosakai-dev-unsubscribe@**
>>>> collab.sakaiproject.org<tosakai-dev-unsubscribe at collab.sakaiproject.org> <mailto:
>>>> sakai-dev-unsubscribe@**collab.sakaiproject.org<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
>>
>
--
Nguni Phakela
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130221/136470d0/attachment.html
More information about the sakai-dev
mailing list