[Building Sakai] Report containing ammount of time Instructor was online

[Feliz Gouveia]

Not sure if it is what is needed, there's an "average time spent on
site" and a way of customizing a report to give the time for each
visit to the site.

There are also other interesting statistics to get an idea of what
people are doing when on the site.

Feliz

On 30 July 2013 00:28, Steve Swinsburg <steve.swinsburg at gmail.com> wrote:
> Hi,
>
> I was about to say that sitestats gives you this information, but its stored
> as a date, not a datetime (sst_userstats).
>
> So you'll need to look at the sakai_session and sakai_event tables to
> calculate the time between the user.login and user.logout events - join
> through on session_id to get the user id, with a further join to
> sakai_user_id_map to get the username  - if you want a specific site, use
> pres.begin and pres.end and join it to the context, which is the siteid.
>
> cheers,
> Steve
>
>
> On Tue, Jul 30, 2013 at 12:01 AM, Gabriel Slomka
> <gabriel.slomka at puc-campinas.edu.br> wrote:
>>
>> Hello there.
>>
>>
>>
>> This is somehow a simple question but im not sure if it hás a simple
>> solution. I wish to know IF its possible to know how much time na Instructor
>> got online. I belive this could be done theorically in two ways : One way is
>> reading directly some data from MySQL to conclude the time online, other to
>> make a plugin/tool that does this.
>>
>>
>>
>>   Does anyone knows the Best aproach for this ? Could i use any session
>> tables to obtain a kind of precise time the user was online ?
>>
>>
>>
>> Thanks alot for any help, and thanks for the attention !
>>
>>
>>
>> Best regards, Gabriel
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"



-- 
Feliz Ribeiro Gouveia

Universidade Fernando Pessoa            http://www.ufp.pt
Centro de Recursos Multimediaticos      Tel 351-22.507.13.06
M.I.N.D. Lab                            Fax 351-22.550.82.69
Pr 9 de Abril 349                       fribeiro at ufp.edu.pt
P-4249-004 Porto