SSIS Components for Box

Build 23.0.8839

UserEvents

Query the available Events in Box.

テーブル固有の情報

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

Select

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

SELECT * FROM UserEvents

If you're authenticated as an administrator with user impersonation permissions, you can query user events from multiple user accounts:

SELECT * FROM UserEvents WHERE AsUserId IN (SELECT Id FROM Users)

Note: User impersonation has the following limitations:

  • The authenticated user cannot be impersonated unless that user is a service account.
  • If the authenticated user is a standard user account, they can only query user events associated with their account.
  • User events shared with multiple users are only returned for one of the users.

Columns

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.
AdditionalDetails String This object provides additional information about the event if available. This can include how a user performed an event as well as additional information to correlate an event to external KeySafe logs. Not all events have an additional_details object. This object is only available in the Enterprise Events.
AsUserId String The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

Pseudo-Columns

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

Name Type Description
StreamType String The type of events to stream.

使用できる値は次のとおりです。all, changes, sync, admin_logs, admin_logs_streaming

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839