Page History

{sql:dataSource=wiki|output=wiki}
select 161061273600/1024/1024 as total, trunc((161061273600 - sum(r.repo_size)*2)/1024/1024) as free, trunc((sum(r.repo_size)*2)/1024/1024) as used from owl_repository r where r.repo_status <> 'deleted'
{sql}

{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}

{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}

{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}

{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}

{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}

{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}