Events
Retrieves team events.
Table Specific Information
The following scopes are required to access this view: events.readSelect
The 本製品 uses the Dropbox API to process search criteria that refer to the StartTime or EndTime columns. The 本製品 processes other filters client-side within the 本製品. 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
StartTime | Timestamp | Filter by start time. |
EndTime | Timestamp | Filter by end time. |