Compartir por

Referencia de tabla o entidad Auditing (Audit)

  • Artigo

Nota

¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.

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

Mensajes

Mensaje Operación de API web Método o clase de SDK
DeleteAuditData DeleteAuditData Action DeleteAuditDataRequest
DeleteRecordChangeHistory DeleteRecordChangeHistory Action DeleteRecordChangeHistoryRequest
Retrieve GET [org URI]/api/data/v9.0/audits(auditid)
Vea Recuperar		 RetrieveRequest o
Retrieve
RetrieveAttributeChangeHistory RetrieveAttributeChangeHistory Function RetrieveAttributeChangeHistoryRequest
RetrieveAuditDetails RetrieveAuditDetails Function RetrieveAuditDetailsRequest
RetrieveAuditPartitionList RetrieveAuditPartitionList Function RetrieveAuditPartitionListRequest
RetrieveMultiple GET [org URI]/api/data/v9.0/audits
Vea Consultar datos		 RetrieveMultipleRequest o
RetrieveMultiple
RetrieveRecordChangeHistory RetrieveRecordChangeHistory Function RetrieveRecordChangeHistoryRequest

Propiedades

Propiedad Valor
CollectionSchemaName Audit
DisplayCollectionName Audits
DisplayName Auditing
EntitySetName audits
IsBPFEntity False
LogicalCollectionName audits
LogicalName audit
OwnershipType None
PrimaryIdAttribute auditid
PrimaryNameAttribute
SchemaName Audit

Columnas/atributos que se pueden escribir

Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.

RegardingObjectId

Propiedad Valor
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

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingobjectidname
MaxLength 400
RequiredLevel None
Type String

UserAdditionalInfo

Propiedad Valor
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

Columnas/atributos de sólo lectura

Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por SchemaName.

Action

Propiedad Valor
Description Actions the user can perform that cause a change
DisplayName Event
IsValidForForm False
IsValidForRead True
LogicalName action
RequiredLevel ApplicationRequired
Type Picklist

Elecciones/opciones de Action

Valor Etiqueta Descripción
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

Propiedad Valor
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

Propiedad Valor
Description Unique identifier of the auditing instance
DisplayName Record Id
IsValidForForm False
IsValidForRead True
LogicalName auditid
RequiredLevel SystemRequired
Type Uniqueidentifier

CallingUserId

Propiedad Valor
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

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName callinguseridname
MaxLength 100
RequiredLevel None
Type String

ChangeData

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
Description Unique identifier of the record that is being audited
DisplayName Record
IsValidForForm False
IsValidForRead True
LogicalName objectid
RequiredLevel SystemRequired
Targets
Type Lookup

ObjectIdName

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName objectidname
MaxLength 160
RequiredLevel None
Type String

ObjectTypeCode

Propiedad Valor
Description Unique identifier of the entity that is being audited
DisplayName Entity
IsValidForForm False
IsValidForRead True
LogicalName objecttypecode
RequiredLevel None
Type EntityName

Operation

Propiedad Valor
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

Elecciones/opciones de Operation

Valor Etiqueta Descripción
1 Create
2 Update
3 Delete
4 Access
5 Upsert
115 Archive
116 Retain
117 RollbackRetain
118 Restore
200 CustomOperation

TransactionId

Propiedad Valor
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

Propiedad Valor
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

Propiedad Valor
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName useridname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

Añadido por: solución NonRelational Data Provider Custom Actions

Propiedad Valor
Description Version number of the audit.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

Relaciones de varios a uno

Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por SchemaName.

lk_audit_userid

Consulte la relación de uno a varios lk_audit_userid de la tabla systemuser.

lk_audit_callinguserid

Consulte la relación de uno a varios lk_audit_callinguserid de la tabla systemuser.

Consultar también

Referencia de tabla o entidad de Dataverse Referencia de la API web audit EntityType