Auditing (Audit) テーブル/エンティティの参照

  • [アーティクル]

注意

テーブルとエンティティの違いについて不明な点がありますか? 開発者: Microsoft Dataverse の用語を理解するを参照してください。

Track changes to records for analysis, record keeping, and compliance.

メッセージ

メッセージ Web API 操作 SDK クラスまたはメソッド
DeleteAuditData DeleteAuditData Action DeleteAuditDataRequest
DeleteRecordChangeHistory DeleteRecordChangeHistory Action DeleteRecordChangeHistoryRequest
Retrieve GET [org URI]/api/data/v9.0/audits(auditid)
取得を参照		 RetrieveRequest または
Retrieve
RetrieveAttributeChangeHistory RetrieveAttributeChangeHistory Function RetrieveAttributeChangeHistoryRequest
RetrieveAuditDetails RetrieveAuditDetails Function RetrieveAuditDetailsRequest
RetrieveAuditPartitionList RetrieveAuditPartitionList Function RetrieveAuditPartitionListRequest
RetrieveMultiple GET [org URI]/api/data/v9.0/audits
データのクエリを参照		 RetrieveMultipleRequest または
RetrieveMultiple
RetrieveRecordChangeHistory RetrieveRecordChangeHistory Function RetrieveRecordChangeHistoryRequest

プロパティ

プロパティ 値
CollectionSchemaName Audit
DisplayCollectionName Audits
DisplayName Auditing
EntitySetName audits
IsBPFEntity False
LogicalCollectionName audits
LogicalName audit
OwnershipType None
PrimaryIdAttribute auditid
PrimaryNameAttribute
SchemaName Audit

書き込み可能な列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate のいずれかについて true を返します (通常は両方)。 SchemaName が一覧表示。

RegardingObjectId

プロパティ 値
Description Unique identifier of the object with which the record is associated.
DisplayName Regarding
IsValidForForm True
IsValidForRead True
LogicalName regardingobjectid
RequiredLevel None
Targets
Type Lookup

RegardingObjectIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingobjectidname
MaxLength 400
RequiredLevel None
Type String

UserAdditionalInfo

プロパティ 値
Description Additional information associated to the user who caused the change.
DisplayName User Info
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName useradditionalinfo
MaxLength 350
RequiredLevel None
Type String

読み取り専用列/属性

これらの列/属性は IsValidForCreate または IsValidForUpdate の両方について false を返します。 SchemaName が一覧表示。

Action

プロパティ 値
Description Actions the user can perform that cause a change
DisplayName Event
IsValidForForm False
IsValidForRead True
LogicalName action
RequiredLevel ApplicationRequired
Type Picklist

Action の選択肢/オプション

値 ラベル 内容
0 Unknown
1 Create
2 Update
3 Delete
4 Activate
5 Deactivate
6 Upsert
11 Cascade
12 Merge
13 Assign
14 Share
15 Retrieve
16 Close
17 Cancel
18 Complete
20 Resolve
21 Reopen
22 Fulfill
23 Paid
24 Qualify
25 Disqualify
26 Submit
27 Reject
28 Approve
29 Invoice
30 Hold
31 Add Member
32 Remove Member
33 Associate Entities
34 Disassociate Entities
35 Add Members
36 Remove Members
37 Add Item
38 Remove Item
39 Add Substitute
40 Remove Substitute
41 Set State
42 Renew
43 Revise
44 Win
45 Lose
46 Internal Processing
47 Reschedule
48 Modify Share
49 Unshare
50 Book
51 Generate Quote From Opportunity
52 Add To Queue
53 Assign Role To Team
54 Remove Role From Team
55 Assign Role To User
56 Remove Role From User
57 Add Privileges to Role
58 Remove Privileges From Role
59 Replace Privileges In Role
60 Import Mappings
61 Clone
62 Send Direct Email
63 Enabled for organization
64 User Access via Web
65 User Access via Web Services
100 Delete Entity
101 Delete Attribute
102 Audit Change at Entity Level
103 Audit Change at Attribute Level
104 Audit Change at Org Level
105 Entity Audit Started
106 Attribute Audit Started
107 Audit Enabled
108 Entity Audit Stopped
109 Attribute Audit Stopped
110 Audit Disabled
111 Audit Log Deletion
112 User Access Audit Started
113 User Access Audit Stopped
115 Archive
116 Retain
117 RollbackRetain
118 IPFirewallAcccesDenied
119 IPFirewallAcccesAllowed
120 Restore
121 ApplicationBasedAccessDenied
122 ApplicationBasedAccessAllowed

AttributeMask

プロパティ 値
Description Contains a CSV of the ColumnNumber metadata property of attributes
DisplayName Changed Field
Format Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName attributemask
MaxLength 2000
RequiredLevel None
Type Memo

AuditId

プロパティ 値
Description Unique identifier of the auditing instance
DisplayName Record Id
IsValidForForm False
IsValidForRead True
LogicalName auditid
RequiredLevel SystemRequired
Type Uniqueidentifier

CallingUserId

プロパティ 値
Description Unique identifier of the calling user in case of an impersonated call
DisplayName Calling User
IsValidForForm False
IsValidForRead True
LogicalName callinguserid
RequiredLevel None
Targets systemuser
Type Lookup

CallingUserIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName callinguseridname
MaxLength 100
RequiredLevel None
Type String

ChangeData

プロパティ 値
Description Contains a CSV of old values of all the attributes whose IsAuditEnabled property is True and are being changed
DisplayName Change Data
Format Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName changedata
MaxLength 2000
RequiredLevel None
Type Memo

CreatedOn

プロパティ 値
DateTimeBehavior UserLocal
Description Date and time when the audit record was created.
DisplayName Changed Date
Format DateAndTime
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime

ObjectId

プロパティ 値
Description Unique identifier of the record that is being audited
DisplayName Record
IsValidForForm False
IsValidForRead True
LogicalName objectid
RequiredLevel SystemRequired
Targets
Type Lookup

ObjectIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName objectidname
MaxLength 160
RequiredLevel None
Type String

ObjectTypeCode

プロパティ 値
Description Unique identifier of the entity that is being audited
DisplayName Entity
IsValidForForm False
IsValidForRead True
LogicalName objecttypecode
RequiredLevel None
Type EntityName

Operation

プロパティ 値
Description The action that causes the audit--it will be create, delete, update, upsert or archive
DisplayName Operation
IsValidForForm False
IsValidForRead True
LogicalName operation
RequiredLevel SystemRequired
Type Picklist

Operation の選択肢/オプション

値 ラベル 内容
1 Create
2 Update
3 Delete
4 Access
5 Upsert
115 Archive
116 Retain
117 RollbackRetain
118 Restore
200 CustomOperation

TransactionId

プロパティ 値
Description Unique identifier for multiple changes that are part of a single operation; this field contains the same GUID for all the audit rows generated in a single transaction
DisplayName Transaction Id
IsValidForForm False
IsValidForRead True
LogicalName transactionid
RequiredLevel SystemRequired
Type Uniqueidentifier

UserId

プロパティ 値
Description Unique identifier of the user who caused a change
DisplayName Changed By
IsValidForForm False
IsValidForRead True
LogicalName userid
RequiredLevel SystemRequired
Targets externalparty,systemuser
Type Lookup

UserIdName

プロパティ 値
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName useridname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

追加元 : NonRelational Data Provider Custom Actions ソリューション

プロパティ 値
Description Version number of the audit.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

多対一関連付け

各多対一の関係付けは、関連するテーブルとの対応する一対多の関係付けによって定義されます。 SchemaName が一覧表示。

lk_audit_userid

systemuser テーブル/エンティティの一対多のリレーションシップ lk_audit_userid を参照してください。

lk_audit_callinguserid

systemuser テーブル/エンティティの一対多のリレーションシップ lk_audit_callinguserid を参照してください。

関連項目

Dataverse テーブル/エンティティ参照 Web API リファレンス audit EntityType