Retrieves team events.

Table Specific Information

The following scopes are required to access this view: events.read

Select

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.