turbot/slack

steampipe plugin install slacksteampipe plugin install slack

Table: slack_search

Searches for messages and files matching a query.

NOTE: The slack_search table requires the query field to be specified in all queries, otherwise it does not know what to search for.

Examples

Search for anything using standard slack search syntax

select
user_name,
timestamp,
channel ->> 'name' as channel,
text
from
slack_search
where
query = 'in:#steampipe from:nathan urgent after:3/12/2021';

Consolidate results of multiple searches

select
user_name,
timestamp,
channel ->> 'name' as channel,
text
from
slack_search
where
query in('in:#steampipe from:nathan urgent after:3/12/2021', 'in:#steampipe from:kai urgent after:3/12/2021');

.inspect slack_search

Search slack for anything using a query.

NameTypeDescription
attachmentsjsonbAttachments matching the query.
blocksjsonbBlock sections in the matching artifact.
channeljsonbChannel or conversation where the search result was found.
permalinktextURL for the search result.
querytextThe search query.
texttextSearch result text, including query.
timestamptimestamp without time zoneTimestamp of the matching artifact.
typetextType of the artifact matching the search.
user_idtextID of the user responsible for the matching text.
user_nametextName of the user responsible for the matching text.