...
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 |