Table: slack_user
Slack workspace users.
Examples
List all users (includes deleted)
select *from slack_user
Get user by ID
select *from slack_userwhere id = 'U0K7FH41E';
Get user by email
select *from slack_userwhere email = 'jim.harper@dundermifflin.com';
List all workspace admins
select id, display_name, real_namefrom slack_userwhere is_admin;
List all bots
select id, real_namefrom slack_userwhere is_bot;
List all single channel guests
select id, real_namefrom slack_userwhere is_ultra_restricted;
.inspect slack_user
Slack workspace users.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
api_app_id | text | If an app user, then this is the unique identifier of the installed Slack application. |
bot_id | text | If a bot user, this is the unique identifier of the bot. |
color | text | Used in some clients to display a special username color. |
deleted | boolean | True if the user has been deleted. |
display_name | text | Indicates the display name that the user has chosen to identify themselves by in their workspace profile. |
display_name_normalized | text | The display name, but with any non-Latin characters filtered out. |
text | Email address of the user. | |
first_name | text | First name of the user. |
has_2fa | boolean | True if two-factor authentication is enabled for the user. |
id | text | Unique identifier for the user. |
image_192 | text | URL of the user profile image, size 192x192 pixels. |
image_24 | text | URL of the user profile image, size 24x24 pixels. |
image_32 | text | URL of the user profile image, size 32x32 pixels. |
image_48 | text | URL of the user profile image, size 48x48 pixels. |
image_512 | text | URL of the user profile image, size 512x512 pixels. |
image_72 | text | URL of the user profile image, size 72x72 pixels. |
image_original | text | URL of the user profile image, original size. |
is_admin | boolean | True if the user is an administrator of the current workspace. |
is_app_user | boolean | True if the user is an owner of the current workspace. |
is_bot | boolean | True if the user is a bot. |
is_invited_user | boolean | True if the user joined the workspace via an invite. |
is_owner | boolean | True if the user is an owner of the current workspace. |
is_primary_owner | boolean | True if the user is the primary owner of the current workspace. |
is_restricted | boolean | Indicates 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_stranger | boolean | If 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_restricted | boolean | Indicates whether or not the user is a single-channel guest. |
job_title | text | Job title of the user. |
last_name | text | Last name of the user. |
locale | text | IETF language code for the user's chosen display language. |
phone | text | Phone number of the user. |
profile_fields | jsonb | Custom fields for the profile. |
real_name | text | The real name that the user specified in their workspace profile. |
real_name_normalized | text | The real_name field, but with any non-Latin characters filtered out. |
skype | text | Skype handle of the user. |
status_emoji | text | Status emoji the user has set. |
status_expiration | timestamp with time zone | Expiration for the user status. |
status_text | text | Status text the user has set. |
team_id | text | The team workspace that the user is a member of. |
tz | text | A human-readable string for the geographic timezone-related region this user has specified in their account. |
tz_label | text | Describes the commonly used name of the timezone. |
tz_offset | bigint | Indicates the number of seconds to offset UTC time by for this user's timezone. |
updated | timestamp with time zone | Time when the user was last updated. |