UserEvents

Query the available Events in Box.

テーブル固有の情報

User events はユーザーアカウントで変更後に保存されたログです。

カレントユーザーのすべてのイベントをクエリします：

SELECT * FROM UserEvents


Name	Type	Description
Id [KEY]	String	The Id of the event.
SourceId	String	The Id of the source that triggered the event.
SourceType	String	The type of the source that triggered the event.
CreatedById	String	The Id of the user that created the event.
CreatedByName	String	The Name of the user that created the event.
CreatedByLogin	String	The Login of the user that created the event.
CreatedAt	Datetime	The date the event was created at. This can only be used when requesting the events with a StreamType of admin_logs
RecordedAt	Datetime	The date the event was recorded at.
SessionId	String	The Id of the session of the event.
EventType	String	The type of the event.
ClassificationName	String	The classification name of the event.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
StreamType	String	The type of events to stream. 使用できる値は次のとおりです。all, changes, sync, admin_logs
AsUserId	String	The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.