Page Comparison

...

• Smartsite Logins to Date
  • Query:

    No Format
    SELECT COUNT(*) FROM SAKAI_SESSION where SESSION_START!=SESSION_END}}

  • Notes: This tracks sessions/users that are complete. Ie, a logout or timeout must have occurred for it to show up here.
• Smartsite Logins in the Past 24 Hours
  • Query:

    No Format
    SELECT COUNT(*) FROM SAKAI_SESSION where SESSION_START!=SESSION_END AND (SYSDATE - SESSION_START) < 10}

  • Notes: Same as the above with the caveat that the session must have started in the past 24 hours, and it does not matter when the session ended.
• Course Sites
  • Query:

    No Format
    SELECT COUNT(DISTINCT TITLE) from SAKAI_SITE WHERE TYPE='course' AND PUBLISHED=1 AND JOINABLE=1 ORDER BY TITLE

  • Notes: none
• Project Sites
  • Query:

    No Format
    SELECT COUNT(*) from SAKAI_SITE WHERE TYPE='project' AND PUBLISHED=1

  • Notes: none
• Training Sites
  • Query:

    No Format
    SELECT COUNT(*) FROM SAKAI_SITE WHERE (TYPE='training-course' OR TYPE='training-project')

  • Notes: none
• Unique Users
  • Query:

    No Format
    SELECT COUNT(DISTINCT USER_ID) FROM SAKAI_REALM_RL_GR WHERE USER_ID NOT IN (SELECT USER_ID FROM SAKAI_USER) AND ROLE_KEY IN (3,5,6,8,9,10,30)

  • Notes: This query returns provided users that have a meaningful(ie, not automatic) role in a site. In some cases this is only the user's My Workspace site.

...

• (Each time)
  • Query:

    No Format
    SELECT count(*) FROM SAKAI_SESSION WHERE SESSION_START!= SESSION_END AND (SYSDATE - SESSION_START) < 10 AND TO_CHAR( NEW_TIME(SESSION_START,'GMT', 'PDT'), 'HH24') = ?

  • Notes: This is just a variation of Logins in the Past 24 Hours from General Statistics. All it does in additional is extract the hour in 24 hour clock mode(after converting due to the time being in GMT and not PDT.) The code loops through this for each hour of the day and presents the table as shown.

...