{sql:dataSource=wiki|output=wiki}
select 218000000000/1024/1024 as total, trunc((218000000000 - sum(dr.repo_size)*2)/1024/1024) as free, trunc((sum(dr.repo_size)*2)/1024/1024) as used from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted'
{sql}
Card
label
svn.rice.edu
svn.rice.edu Charts
Chart
3D
false
ylabel
Size in Megabytes
timePeriod
Day
categoryLabelPosition
down45
type
bar
dataOrientation
vertical
title
Top 10 Repository Sizes
colors
blue
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'svn' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 10 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'svn' group by name order by revision desc limit 10
{sql}
Card
label
it.svn.rice.edu
it.svn.rice.edu Charts
Chart
3D
false
ylabel
Size in Megabytes
timePeriod
Day
categoryLabelPosition
down45
type
bar
dataOrientation
vertical
title
Top 10 Repository Sizes
colors
blue
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 10 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'it.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}
Card
label
hpc.svn.rice.edu
hpc.svn.rice.edu Charts
Chart
3D
false
ylabel
Size in Megabytes
timePeriod
Day
categoryLabelPosition
down45
type
bar
dataOrientation
vertical
title
Top 10 Repository Sizes
colors
blue
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'hpc.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 10 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'hpc.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}