Slide 53
Slide 53 text
Git Usage Monitoring
/opt/backup-utils/bin/ghe-backup
SELECT
DATE_FORMAT(pull_requests.merged_at, '%Y-%m') AS date,
'Merged Pull Requests' AS type,
COUNT(*) AS count
FROM pull_requests AS pr, users
WHERE
pr.merged_at > (NOW() - INTERVAL 2 YEAR) AND
pr.merged_at < DATE_FORMAT(CURRENT_DATE,'%Y-%m-01') AND
user_id = users.id
GROUP BY 1
ORDER BY 1,2
Merged Pull Requests per month?