steampipe plugin install linear

Table: linear_user - Query Linear User using SQL

Linear is a streamlined software project management service, designed to help teams prioritize tasks, manage projects, and track their progress. It provides a centralized platform to manage all aspects of a software project, from issue tracking to sprint planning. Linear helps teams stay organized, move work forward, and continuously improve their processes.

Table Usage Guide

The linear_user table provides insights into users within the Linear platform. As a project manager or team lead, explore user-specific details through this table, including usernames, email addresses, and associated team information. Utilize it to uncover information about user activity, such as task assignment, project involvement, and user status within the platform.

Important Notes

  • There are three types of users in Linear:
    • Admins: Admins have full access to a workspace and can manage team members.
    • Members: Members have read-write access to a workspace and can participate in team discussions.
    • Guests: Guests have read-only access to a workspace and cannot participate in team discussions.

Examples

Basic info

Explore which users are active or inactive, along with their admin status and personalized status labels. This can be particularly useful for understanding the overall user activity and administrative roles within your Linear organization.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user;

List admin users

Uncover the details of which users have administrative privileges in your system. This information is crucial to understand who has elevated access and can make significant changes to your configurations.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
admin;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
admin = 1;

List inactive users

Discover the segments that consist of inactive users within your system. This allows for efficient user management, enabling you to identify and possibly re-engage or remove these dormant profiles.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
not active;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
active = 0;

Show details of the currently authenticated user

Explore the details of your user profile on Linear, including your status and administrative privileges. This can be useful for understanding your permissions and activity within the platform.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
is_me;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
is_me = 1;

List guest users

Explore which users are guests in your system. This is useful for managing access rights and ensuring appropriate levels of user permissions.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
guest;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
guest;

List archived users

Discover the segments that consist of archived users in your system. This can be beneficial to identify inactive users, assess their previous contributions, and manage system resources more effectively.

select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
archived_at is not null;
select
id,
title,
active,
admin,
created_at,
email,
status_emoji,
status_label,
updated_at
from
linear_user
where
archived_at is not null;

Schema for linear_user

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
activeboolean=Whether the user account is active or disabled (suspended).
adminboolean=Whether the user is an organization administrator.
archived_attimestamp with time zoneThe time at which the entity was archived. Null if the entity has not been archived.
avatar_urltextAn URL to the user's avatar image.
created_attimestamp with time zone=, >, >=, <=, <The time at which the entity was created.
created_issue_countbigintNumber of issues created.
descriptiontextA short description of the user, either its title or bio.
disable_reasontextReason why is the account disabled.
display_nametext=The user's display (nick) name. Unique within each organization.
emailtext=The user's email address.
guestbooleanWhether the user is a guest in the workspace and limited to accessing a subset of teams.
idtext=The unique identifier of the entity.
invite_hashtextUnique hash for the user to be used in invite URLs.
is_meboolean=Whether the user is the currently authenticated user.
last_seentimestamp with time zoneThe last time the user was seen online. If null, the user is currently online.
nametext=The user's full name.
organizationjsonbOrganization the user belongs to.
status_emojitextThe emoji to represent the user current status.
status_labeltextThe label of the user current status.
status_until_attimestamp with time zoneA date at which the user current status should be cleared.
timezonetextThe local timezone of the user.
titletextThe user's title.
updated_attimestamp with time zone=, >, >=, <=, <The last time at which the entity was meaningfully updated, i.e. for all changes of syncable properties except those for which updates should not produce an update to updatedAt (see skipUpdatedAtKeys). This is the same as the creation time if the entity hasn't been updated after creation.
urltextUser's profile URL.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linear

You can pass the configuration to the command with the --config argument:

steampipe_export_linear --config '<your_config>' linear_user