Slack Search Results Report (Save As CSV)
- Dave Ruel
You may save your search results to a CSV file by selecting the “Save as CSV” option at any time. Reports that are generated can be downloaded from the “Reports” tab on the main interface. The search results CSV file contains the following metadata fields:
Column Name | Description | Example |
|---|---|---|
Matter | Name of Matter in Hanzo Illuminate | PDX vs NYC |
Workspace | Name of Slack Workspace | Acme Workspace |
Channel Name | The name of the channel in Slack | Dogs vs Cats |
Channel ID | The Slack Channel ID as shown within Slack | C2GH83T3T |
Channel Type | The type of created within Slack | Private or Public |
Occurred On | The date the message occurred in Slack (Displayed on UTC Date) Displayed in MM/DD/YYYY | 04/05/2018 |
Time Stamp | The time stamp of the message displayed in UTC. Displayed in HH:MM:SS UTC | 16:11:21 UTC |
User Full Name | The full name of the Slack name as input within Slack. This name field may be blank if searching non-Slack data or if a full user name was not input into Slack | Robert Pine |
User ID | The Slack User ID. The filed may be blank if not searching for Slack content | W7H9GDXET |
Message Sub Type | The type of message within Slack. | deleted |
Message | Original Slack message content. Slack Users will be shown as the original Slack User ID | <@W7H9TEGKE> has joined the channel I wish we had more time off for the 4th of July |
Attachment Name | The name of the attachment when uploaded to Slack | NFL_Draft_List_2023.pdf |
Message Notification Datetime | The date and time of a message when edited or deleted in Slack. Message is shown in MM/DD/YYYY HH:MM:SS UTC | 04/05/2023 14:35:07 UTC |
Slack Search Results “Save As CSV” metadata
Slack Search Results “Save As CSV” now contain additional metadata information.
Old Column Name | New Column Name | Change Type |
Matter | Matter Name | Rename - (Add “Name” to the matter name |
| Matter ID | New - The internal ID of the matter. This field is present in all matter-related reports and can be used as a key or overlay key between various reports |
Workspace | Workspace/Team Name | Rename - The name of the workspace or team name. Blank if not available. |
| Workspace ID | New - The Slack ID of the Workspace or Team |
Channel Name | Channel Name | No Change - the name of the Channel that the message was sent in |
Channel ID | Channel ID | No Change - the Slack ID of the Channel that the message was sent in |
Channel Type | Channel Type | No Change - The type of the channel (DM, Group, Public, Private) |
Occurred On | Occurred On | No Change - the Day the message was sent - deprecated |
Time Stamp | Time Stamp | No Change - the time of day the message was sent - deprecated |
| Message Time UTC | New - Date/time when the message was sent, in UTC example (yyyy-mm-dd hh:mm:ss) |
User Full Name | User Full Name | No Change - Full Name of the user who sent the message |
User ID | Slack User ID | Rename - Add “Slack” prefix - Slack user ID of the user who sent the message |
Message Sub Type | Message Sub Type | No Change - sub-type of the message:
|
Message | Message | No Change - the text of the message |
| Slack Message ID | New - Slack ID of this message (ie the Slack Message’s “ts” value as defined by Slack). This value is currently presented with 1-second granularity. |
| Parent Message ID | New - Slack ID of this message’s parent message (i.e. the “parent” Slack Message’s “TS” value, as defined by Slack, for which the current message is a thread reply, edit or delete). This is currently presented with 1-second granularity. Will be left blank if a message has no parent (if message sub-type is empty) |
Message Modification Datetime | Message Modification Datetime | No Change - The date and time when the modification (edit/delete) of an earlier message occurred - deprecated |
| Message Modification Time UTC | New - Date/Time when the modification of an earlier message occurred, in UTC e.g. yyyy-mm-dd hh:mm:ss Blank if the message has no parent (if Message Sub Type is empty) |
Attachment Name | Attachment File Name | Rename - include “file” in the header name - a comma-separated list of attachments will be listed if there is more than one attachment |
| Attachment File Extension | New - A comma separated list of attachment file extensions (if more than one file) |
| Attachment ID | New - A comma separated list of internal unique ID’s (matching Attachment File Name List) |
Search Results Report Main Page