{sql:dataSource=wiki|output=wiki}
select 218000000000/1024/1024 as total, trunc((218000000000 - sum(d.repo_size)*2)/1024/1024) as free, trunc((sum(d.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}
...
Chart
3D
false
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 5 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select d.repo_group_code || '.' || d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data where 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 <> 'it.svndeleted' and d.repo_group_namecode <> 'subversionit.svn' and d.repo_statusname <> 'deletedsubversion' group by name order by revision desc limit 5
{sql}