turbot / steampipe-plugin-github

Use SQL to instantly query repositories, users, gists and more from GitHub. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/github
Apache License 2.0
72 stars 28 forks source link

Add table github_outside_collaborator #404 #411

Closed ParthaI closed 5 months ago

ParthaI commented 5 months ago

Example query results

Results ``` > select * from github_organization_collaborator where organization = 'pro-cloud-49' +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ | organization | affiliation | repository_name | permission | user_login | _ctx | +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ | pro-cloud-49 | ALL | test37 | READ | {"company":"","email":"","login":"bsdmisra","name":"dhs lskdy","url":"https://github.com/bsdmisra"} | {"connection_name":"github","steampipe":{"sdk_version":"5.8.0"}} | | pro-cloud-49 | ALL | test37 | ADMIN | {"company":"","email":"","login":"PsndjI","name":"","url":"https://github.com/PsndjI"} | {"connection_name":"github","steampipe":{"sdk_version":"5.8.0"}} | | pro-cloud-49 | ALL | access-control | ADMIN | {"company":"","email":"","login":"PsndjI","name":"","url":"https://github.com/PsndjI"} | {"connection_name":"github","steampipe":{"sdk_version":"5.8.0"}} | +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ > select * from github_organization_collaborator where organization = 'pro-cloud-49' and affiliation = 'OUTSIDE' +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ | organization | affiliation | repository_name | permission | user_login | _ctx | +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ | pro-cloud-49 | OUTSIDE | test37 | READ | {"company":"","email":"","login":"bsdmisra","name":"dhs lskdy","url":"https://github.com/bsdmisra"} | {"connection_name":"github","steampipe":{"sdk_version":"5.8.0"}} | +--------------+-------------+-----------------+------------+-----------------------------------------------------------------------------------------------------+------------------------------------------------------------------+ ```