Sites created

From UFP-UV Sakai Wiki

Jump to: navigation, search
-- Sites created for this year
SELECT TYPE,count(*) AS TOTAL FROM sakai.SAKAI_SITE
WHERE CREATEDON > '2010-07-31 23:59:59'
-- and CREATEDON < '2009-01-27 00:00:00'
AND TYPE IS NOT NULL
GROUP BY TYPE;
 
 
-- Sites which have content creation activity on SiteStats
SELECT TYPE,count(DISTINCT(SA.SITE_ID)) AS CONTENT_NEW
FROM sitestats.SST_SITEACTIVITY SA, sakai.SAKAI_SITE S
WHERE S.SITE_ID=SA.SITE_ID
AND EVENT_ID='content.new'
AND CREATEDON > '2010-07-31 23:59:59'
-- and CREATEDON < '2009-01-27 00:00:00'
AND TYPE IS NOT NULL
GROUP BY TYPE;
Personal tools