Stuff about Wikis 2 (from Hubing)

Totals of.....	12/20/07	04/02/08	6/11/08	7/9/08	8/4/2008	10/13/2008	10/20/2008	1/24/2009	2/24/2009	4/27/2009	SQL
Spaces	201	377	564	632	689	862	910	1120	1280	1366	select count(*)from SPACES;
Unique Users	1058	1708	2272	2704	3044	5981	6479	8130	9129	9697	select count(*)from external_entities;
Unique Users that made an edit	239	479	670	733	818	1217	1294	1624	1854	2005	select count(distinct(USERNAME)) from CONTENT;
Unique Labels	238	470	727	762	846	1019	1046	1234	1413	1460	select count(distinct(NAME)) from LABEL;
Edits	9671	26639	35591	40311	45946	62775	67507	87089	108494	119716	select count(*)from CONTENT;
ITS employees	423	474	493	496	509	517	520	530	538	538	grab the output of select name from external_entities and put it in file name foo and cat foo \| awk {'print $1'} \| xargs -n 1 -I{} ldapsearch -x -h ldap.psu.edu uid={} psAdminarea \| grep "INFORMATION TECH SERVICES" \| wc'
ITS employees that have made an edit	N/A	233	270	277	294	330	335	358	378	379	take output of select distinct(USERNAME) from CONTENT; and feed it to above script

Unknown macro: {chart}

	12/20/2007	04/02/2008	6/11/2008	7/9/2008	8/4/2008	10/13/2008	10/29/2008	1/24/2009	3/23/2009	4/27/2009
Spaces	201	377	564	632	689	862	910	1120	1280	1366
Unique Users that made an edit	239	479	670	733	818	1217	1294	1624	1854	2005
Unique Labels	238	470	727	762	846	1019	1046	1234	1413	1460
ITS employees	423	474	493	496	509	517	520	530	538	538
ITS employees that have made an edit	N/A	233	270	277	294	330	335	358	378	379

Unknown macro: {chart}

	12/20/2007	04/02/2008	6/11/2008	7/9/2008	8/4/2008	10/13/2008	10/29/2008	11/11/2008	1/24/2009	3/23/2009	4/27/2009
Unique Users	1058	1708	2272	2704	3044	5981	6479	6686	8130	9129	9697

Unknown macro: {chart}

	12/20/2007	04/02/2008	6/11/2008	7/9/2008	8/4/2008	10/13/2008	10/29/2008	11/11/2008	1/24/2009	3/23/2009	4/27/2009
Edits	9671	26639	35591	40311	45946	62775	67507	70579	87089	108494	119716