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

  • No labels