Description

This chart shows the top operating systems used by projects in Alioth.

Visualization

SQL Script

SELECT os AS System, COUNT( unixname ) AS Count
FROM al_projects_os
WHERE datasource_id = <current>
GROUP BY System
ORDER BY Count DESC;


Description

This chart shows the top operating systems used by projects in Rubyforge.

Visualization

SQL Script

SELECT rfop.description AS System, COUNT( DISTINCT rfop.proj_unixname ) AS Count
FROM rf_project_operating_system rfop
WHERE rfop.datasource_id = <current>
GROUP BY System
ORDER BY Count DESC;


Description

This chart shows the top operating systems used by projects in Objectweb.

Visualization

SQL Script

SELECT owop.description AS System, COUNT( DISTINCT owop.proj_unixname ) AS Count
FROM ow_project_operating_system owop
WHERE owop.datasource_id = <current>
GROUP BY System
ORDER BY Count DESC;


Description

This chart shows the top operating systems used by projects in Rubyforge.

Visualization

SQL Script

SELECT rfop.description, count(DISTINCT rfop.proj_unixname) AS system
FROM rf_project_operating_system rfop
WHERE rfop.datasource_id = <current>
GROUP BY rfop.description
ORDER BY system DESC;


Description

This chart shows the top operating systems used by projects in Sourceforge.

Visualization

SQL Script

SELECT pop.description, count(DISTINCT pop.proj_unixname) AS system
FROM project_operating_system pop
WHERE pop.datasource_id = <current>
GROUP BY pop.description
ORDER BY system DESC;


Description

This chart shows the top operating systems used by projects in Objectweb.

Visualization

SQL Script

SELECT owop.description, count(DISTINCT owop.proj_unixname) AS system
FROM ow_project_operating_system owop
WHERE owop.datasource_id = <current>
GROUP BY owop.description
ORDER BY system DESC;