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 | Description |
| TeamId [KEY] | String | Id of the team. |
| UserId | String | Id of the user. |
| Username | String | Username of the user. |
| DateFirst | Datetime | The first login date time. |
| DateLast | Datetime | The last login date time. |
| Count | Integer | The login count. |
| IP | String | IP address of the user. |
| UserAgent | String | The user agent with which user logged in. |
| Isp | String | The internet service provider. |
| Country | String | Country. |
| Region | String | Region. |