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

[Steve Swinsburg]

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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130730/63f2cee8/attachment.html