turbot/slack

steampipe plugin install slacksteampipe plugin install slack

Table: slack_user

Slack workspace users.

Examples

List all users (includes deleted)

select
*
from
slack_user

Get user by ID

select
*
from
slack_user
where
id = 'U0K7FH41E';

Get user by email

select
*
from
slack_user
where
email = 'jim.harper@dundermifflin.com';

List all workspace admins

select
id,
display_name,
real_name
from
slack_user
where
is_admin;

List all bots

select
id,
real_name
from
slack_user
where
is_bot;

List all single channel guests

select
id,
real_name
from
slack_user
where
is_ultra_restricted;

.inspect slack_user

Slack workspace users.

NameTypeDescription
api_app_idtextIf an app user, then this is the unique identifier of the installed Slack application.
bot_idtextIf a bot user, this is the unique identifier of the bot.
colortextUsed in some clients to display a special username color.
deletedbooleanTrue if the user has been deleted.
display_nametextIndicates the display name that the user has chosen to identify themselves by in their workspace profile.
display_name_normalizedtextThe display name, but with any non-Latin characters filtered out.
emailtextEmail address of the user.
first_nametextFirst name of the user.
has_2fabooleanTrue if two-factor authentication is enabled for the user.
idtextUnique identifier for the user.
image_192textURL of the user profile image, size 192x192 pixels.
image_24textURL of the user profile image, size 24x24 pixels.
image_32textURL of the user profile image, size 32x32 pixels.
image_48textURL of the user profile image, size 48x48 pixels.
image_512textURL of the user profile image, size 512x512 pixels.
image_72textURL of the user profile image, size 72x72 pixels.
image_originaltextURL of the user profile image, original size.
is_adminbooleanTrue if the user is an administrator of the current workspace.
is_app_userbooleanTrue if the user is an owner of the current workspace.
is_botbooleanTrue if the user is a bot.
is_invited_userbooleanTrue if the user joined the workspace via an invite.
is_ownerbooleanTrue if the user is an owner of the current workspace.
is_primary_ownerbooleanTrue if the user is the primary owner of the current workspace.
is_restrictedbooleanIndicates whether or not the user is a guest user. Use in combination with the is_ultra_restricted field to check if the user is a single-channel guest user.
is_strangerbooleanIf true, this user belongs to a different workspace than the one associated with your app's token, and isn't in any shared channels visible to your app. If false (or this field is not present), the user is either from the same workspace as associated with your app's token, or they are from a different workspace, but are in a shared channel that your app has access to. Read our shared channels docs for more detail.
is_ultra_restrictedbooleanIndicates whether or not the user is a single-channel guest.
job_titletextJob title of the user.
last_nametextLast name of the user.
localetextIETF language code for the user's chosen display language.
phonetextPhone number of the user.
profile_fieldsjsonbCustom fields for the profile.
real_nametextThe real name that the user specified in their workspace profile.
real_name_normalizedtextThe real_name field, but with any non-Latin characters filtered out.
skypetextSkype handle of the user.
status_emojitextStatus emoji the user has set.
status_expirationtimestamp without time zoneExpiration for the user status.
status_texttextStatus text the user has set.
team_idtextThe team workspace that the user is a member of.
tztextA human-readable string for the geographic timezone-related region this user has specified in their account.
tz_labeltextDescribes the commonly used name of the timezone.
tz_offsetbigintIndicates the number of seconds to offset UTC time by for this user's timezone.
updatedtimestamp without time zoneTime when the user was last updated.