chstats.in 3.74 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
#!/usr/bin/perl -w
#
# Copyright (c) 2008-2013 University of Utah and the Flux Group.
# 
# {{{GENIPUBLIC-LICENSE
# 
# GENI Public License
# 
# Permission is hereby granted, free of charge, to any person obtaining
# a copy of this software and/or hardware specification (the "Work") to
# deal in the Work without restriction, including without limitation the
# rights to use, copy, modify, merge, publish, distribute, sublicense,
# and/or sell copies of the Work, and to permit persons to whom the Work
# is furnished to do so, subject to the following conditions:
# 
# The above copyright notice and this permission notice shall be
# included in all copies or substantial portions of the Work.
# 
# THE WORK IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
# OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
# NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
# HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
# WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
# OUT OF OR IN CONNECTION WITH THE WORK OR THE USE OR OTHER DEALINGS
# IN THE WORK.
# 
# }}}
#
use strict;
use English;
use Data::Dumper;
use Getopt::Std;
use POSIX;

#
# Stats!
# 
sub usage()
{
    print STDERR "Usage: chstats\n";
    exit(1);
}
my $optlist    = "";

#
# Configure variables
#
my $TB		  = "@prefix@";
my $TBOPS         = "@TBOPSEMAIL@";
my $PGENISUPPORT  = @PROTOGENI_SUPPORT@;
my $ISCLRHOUSE    = @PROTOGENI_ISCLEARINGHOUSE@;

# un-taint path
$ENV{'PATH'} = '/bin:/usr/bin:/usr/local/bin:/usr/site/bin';
delete @ENV{'IFS', 'CDPATH', 'ENV', 'BASH_ENV'};

# Protos
sub fatal($);

#
# Turn off line buffering on output
#
$| = 1;

# We always use the CH db.
use vars qw($GENI_DBNAME);
$GENI_DBNAME = "geni-ch";

# Now we can load the libraries after setting the proper DB.
use lib '@prefix@/lib';
use libaudit;
require GeniDB;
import GeniDB;
require GeniCertificate;
require GeniAuthority;

#
# Check args.
#
my %options = ();
if (! getopts($optlist, \%options)) {
    usage();
}
usage()
    if (@ARGV);

my $query_result =
    DBQueryFatal("select count(slice_uuid) from aggregate_history");
my ($count) = $query_result->fetchrow_array();
print "Total slivers: $count\n";

$query_result =
    DBQueryFatal("select count(distinct slice_uuid) from aggregate_history");
($count) = $query_result->fetchrow_array();
print "Distinct slices: $count\n";

$query_result =
    DBQueryFatal("select count(distinct creator_urn) from aggregate_history");
($count) = $query_result->fetchrow_array();
print "Distinct users: $count (includes guest,tutorial,etc users)\n";

$query_result =
    DBQueryFatal("select distinct creator_urn from aggregate_history ".
		 "where creator_urn not regexp ".
		 "'user\\\\+(gemini|gpousr|guest|user)'");
$count = $query_result->numrows;
print "Distinct users: $count (no guest users)\n";

$query_result =
    DBQueryFatal("select count(distinct creator_urn) from aggregate_history ".
		 "where hrn like '%emulab.net%'");
($count) = $query_result->fetchrow_array();
print "-> Used Utah: $count\n";

$query_result =
    DBQueryFatal("select count(distinct creator_urn) from aggregate_history ".
		 "where hrn not like '%emulab.net%'");
($count) = $query_result->fetchrow_array();
print "-> Used Other: $count\n";

$query_result =
    DBQueryFatal("select distinct creator_urn from aggregate_history");
my %creator_places = ();
while (my ($creator_place) = $query_result->fetchrow_array()) {
    if (defined($creator_place) && $creator_place =~ /\+(.*)\+/) {
	$creator_places{$1} = 1;
    }
}
$count = scalar(keys(%creator_places));
print "Distinct institutions: $count (includes guest,tutorial,etc users)\n";
#print Dumper(\%creator_places);

sub fatal($)
{
    my ($msg) = @_;

    die("*** $0:\n".
	"    $msg\n");
}