[Building Sakai] count site unique visit

[Sanghyun Jeon]

hello,

SST_SITEVISITS has total_visits and total_unique column.
I am wondering how these results can be counted.
I know SST_SITEVISITS data comes from SAKAI_EVENT and SESSION. Can anybody
tell me the exact query for these results?

One of our instructors does not use sitestats tool but he would like to
know the unique site visit result for the certain timeframe.

Which event do I need to count from SAKAI_EVENT in order to get the same
total_visits and total_unique results?

Thank you in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140410/72231f06/attachment.html