francois2metz/scalingo

steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_collaborator

A collaborator can access a scalingo application.

The scalingo_collaborator table can be used to query information about app collaborators, and you must specify which application in the where or join clause using the app_name column.

Examples

List collaborators of an application

select
status,
email
from
scalingo_collaborator
where
app_name='caresteouvert-api';

Get all collaborators from all apps

select
distinct(c.email) as email
from
scalingo_collaborator as c
inner join
scalingo_app as a
on
a.name = c.app_name

.inspect scalingo_collaborator

A collaborator is someone who have access to an application.

NameTypeDescription
app_idtextID of the application where the collaborator belong.
app_nametextName of the app.
emailtextEmail of the collaborator.
idtextUnique ID identifying the collaborator.
statustextStatus of the invitation.
user_idtextUser id of the collaborator.
usernametextUsername of the collaborator.