turbot/github

GitHub
steampipe plugin install githubsteampipe plugin install github

Table: github_actions_repository_runner

A runner is a server that runs your workflows when they're triggered. Each runner can run a single job at a time. Self-hosted runners offer more control of hardware, operating system, and software tools than GitHub-hosted runners provide.

The github_actions_repository_runner table can be used to query information about any self-hosted runner, and you must specify which repository in the where or join clause using the repository_full_name column.

Examples

List runners

select
*
from
github_actions_repository_runner
where
repository_full_name = 'turbot/steampipe';

List runners with mac operating system

select
repository_full_name,
id,
name,
os
from
github_actions_repository_runner
where
repository_full_name = 'turbot/steampipe' and os = 'macos';

List runners which are in use currently

select
repository_full_name,
id,
name,
os,
busy
from
github_actions_repository_runner
where
repository_full_name = 'turbot/steampipe' and busy;

.inspect github_actions_repository_runner

The runner is the application that runs a job from a GitHub Actions workflow

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
busybooleanIndicates wheather the runner is currently in use or not.
idbigintThe unique identifier of the runner.
labelsjsonbLabels represents a collection of labels attached to each runner.
nametextThe name of the runner.
ostextThe operating system of the runner.
repository_full_nametextFull name of the repository that contains the runners.
statustextThe status of the runner.