TeamAccessLogs
Gets the access logs for the current team.
Select
The add-in uses the Slack API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
The TeamAccessLogs table requires TeamId column in the WHERE clause; otherwise, the driver will automatically add the column.
- TeamId supports the = operator.
SELECT * FROM TeamAccessLogs WHERE TeamId = 'T01LC4ASB3M'
Columns
| Name | Type | References | Description |
| TeamId [KEY] | String | The Id of the team. | |
| UserId | String | The Id of the user who accessed Slack. | |
| Username | String | The username of the user who accessed Slack. | |
| DateFirst | Datetime | The first login date time. | |
| DateLast | Datetime | The last login date time. | |
| Count | Integer | The login count. | |
| IP | String | The IP address of the user. | |
| UserAgent | String | The user agent with which the user logged in. | |
| Isp | String | The internet service provider. | |
| Country | String | The country where the access originated. | |
| Region | String | The region where the access originated. |