Dynamics365Activity

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Tables Index

Reference for Dynamics365Activity table in Azure Monitor Logs.

Attribute Value
Category -
Basic Logs Eligible ✗ No (source)
Supports Transformations ✓ Yes (source)
Ingestion API Supported ✗ No
Lake-Only Ingestion ✗ No (source)
Azure Monitor Tables Reference View Documentation

Contents

Schema (33 columns)

Source: Azure Monitor documentation

Column Name Type Description
_BilledSize real The record size in bytes
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
_ResourceId string A unique identifier for the resource that the record is associated with
_SubscriptionId string A unique identifier for the subscription that the record is associated with
ClientIP string The IP address of the device that was used when the activity was logged
CorrelationId string A unique value used to associate related rows
CrmOrganizationUniqueName string Unique name of the organization
EntityId string Unique identifier of the entity
EntityName string Name of the entity in the organization
Fields dynamic JSON of Key Value pair reflecting the values that were created or updated
InstanceUrl string URL to the instance
ItemType string The type of object that was accessed or modified. See the ItemType table for details on the types of objects
ItemUrl string URL to the record emitting the log
Message string Name of the message called in the Dynamics365 SDK
OfficeWorkload string The Office 365 service where the activity occurred
Operation string The name of the operation that the user is performing
OrganizationId string The GUID for your organization's Office 365 tenant. This value will always be the same for your organization
OriginalObjectId string The ObjectId for SharePoint and OneDrive about business activity
Query string The query filter parameters used while executing the FetchXML
QueryResults dynamic One or multiple unique records returned by the Retrieve and Retrieve Multiple SDK message call
RecordType string The type of operation indicated by the record. See the AuditLogRecordType table in Office 365 management activity api schema documentation for details on the types of audit log records
ResultStatus string Indicates whether the action (specified in the Operation property) was successful or not
ServiceName string Name of the Service generating the log
SourceRecordId string Unique identifier of an audit record
SourceSystem string The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
SystemUserId string Unique identifier of the user GUID in the organization
TenantId string The Log Analytics workspace ID
TimeGenerated datetime The date and time in Coordinated Universal Time (UTC) when the user performed the activity
Type string The name of the table
UserAgent string The user agent
UserId string The UPN (User Principal Name) of the user who performed the action (specified in the Operation property) that resulted in the record being logged
UserKey string An alternative ID for the user identified in the UserId property
UserType string The type of user that performed the operation. See the UserType table in Office 365 management activity api schema documentation for details on the types of users

Schema References

Official Microsoft Learn documentation for field/column information:

Solutions (5)

This table is used by the following solutions:

Connectors (1)

This table is ingested by the following connectors:

Connector Selection Criteria
Dynamics 365

Content Items Using This Table (4)

Workbooks (4)

In solution ContinuousDiagnostics&Mitigation:

Workbook Selection Criteria
ContinuousDiagnostics&Mitigation

In solution MaturityModelForEventLogManagementM2131:

Workbook Selection Criteria
MaturityModelForEventLogManagement_M2131

In solution NISTSP80053:

Workbook Selection Criteria
NISTSP80053

In solution ZeroTrust(TIC3.0):

Workbook Selection Criteria
ZeroTrustTIC3

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Tables Index