larsxschneider/scotty

Helper scripts for GitHub Enterprise admins

scotty's Issues

Add admin script to run fsck on the data device

sudo service ghe-user-disk stop
sudo service ghe-user-disk start
sudo umount /data/user
sudo fsck -y /dev/mapper/ghe_storage_*-ghe_user_data
sudo shutdown -r now

Check GHE version

Before running a script, check the GHE version to ensure we run the script only on a supported GHE version.

/cc @jdennes

Add report script to show what repos a user pushed to last

    SELECT
        CONCAT('https://$GHE_HOST/', org.login, '/', repositories.name) AS repo,
        REPLACE(pushes.ref, 'refs/heads/', '') AS branch,
        pusher.login AS user,
        MAX(pushes.updated_at) AS 'last push date'
    FROM pushes, repositories, users AS org, users AS pusher
    WHERE
        pushes.pusher_id = pusher.id AND
        pushes.repository_id = repositories.id AND
        repositories.owner_id = org.id AND
        org.type = 'Organization' AND
        pusher.login = '$PUSHER'
    GROUP BY repositories.name, pusher.login, pushes.ref
    ORDER BY pushes.updated_at DESC, repositories.name, pushes.ref

Support for GHE 2.11

Could these scripts be made to work with GHE 2.11?

I tested a couple reports,

users-find-inactive.sh
git-versions.sh
exceptions.sh

Which all work ok, after changing the REQUIRED_GHE_MAJOR_VERSION to 2.11