Events
Retrieves team events.
Table Specific Information
The following scopes are required to access this view: events.readSelect
The provider uses the Dropbox API to process search criteria that refer to the StartTime or EndTime columns. The provider processes other filters client-side within the provider. For example, the following queries are processed server side.
SELECT * FROM Events WHERE StartTime = '2020-04-05' SELECT * FROM Events WHERE EndTime = '2020-04-05' SELECT * FROM Events WHERE StartTime = '2020-04-05' AND EndTime = '2020-06-12'
Columns
| Name | Type | Description |
| Timestamp | Timestamp | The Dropbox timestamp representing when the action was taken. |
| Category | String | The category that this type of action belongs to. |
| Type | String | The particular type of action taken. |
| Description | String | The description of the event type. |
| DetailsTag | String | The variable event schema applicable to this type of action, instantiated with respect to this particular action. |
| ErrorUserFriendlyMessage | String | The user-friendly error message. |
| IsEmmManaged | Boolean | Indicator whether the EMM is managed or not. |
| LoginMethod | String | The login method. |
| AppInfoTag | String | Info about the app. |
| AppInfoAppId | String | The ID of the app. |
| AppInfoDisplayName | String | The display name of the app. |
| IsGroupOwner | Boolean | Indicator whether the user is group owner. |
| IsCompanyManaged | Boolean | Indicator whether the company is managed. |
| ActorTag | String | The entity who actually performed the action. Might be missing due to historical data gap. |
| ActorAdminTag | String | The adming tag. |
| ActorAdminAccountId | String | Account ID of the admin. |
| ActorAdminDisplayName | String | Display name of the admin. |
| ActorAdminEmail | String | Email of the admin. |
| ActorAdminTeamMemberId | String | Team member ID of the admin. |
| ActorAppTag | String | The tag of the app. |
| ActorAppId | String | The ID of the app. |
| ActorAppDisplayName | String | The display name of the app. |
| ContextTag | String | The user or team on whose behalf the actor performed the action. Might be missing due to historical data gap. |
| ContextAccountId | String | Account ID of the context. |
| ContextDisplayName | String | Display name of the context. |
| ContextEmail | String | Email of the context. |
| ContextTeamMemberId | String | Team member ID of the context. |
| AccessMethodTag | String | The method that was used to perform the action. |
| EndUserWebSessionId | String | Web session ID. |
| EndUserDesktopSessionId | String | Desktop session ID. |
| EndUserMobileSessionId | String | Mobile session ID. |
| SignInAsWebSessionId | String | Sign-in-as session ID. |
| ContentManagerWebSessionId | String | Content manager session ID. |
| AdminConsoleWebSessionId | String | Admin console session ID. |
| EnterpriseConsoleSessionId | String | Enterprise console session ID. |
| ApiSessionRequestId | String | API request ID. |
| GeoLocationIpAddress | String | IP Address. |
| GeoLocationCity | String | City of the geolocation. |
| GeoLocationRegion | String | Region of the geolocation. |
| GeoLocationCountry | String | Country of the geolocation. |
| InvolveNonTeamMembers | Boolean | Indicator if the event includes a non team member. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| StartTime | Timestamp | Filter by start time. |
| EndTime | Timestamp | Filter by end time. |