2
Dataverse activities can surface in the Compliance centre but are practically unusable.
1. Activities can be system or user generated, there can be 000's of system and '00's of user created.
There is no filter to only reveal user activities so a lot of junk has to be exported to Excel.
2. All Dataverse activities are classed as Dynamics/365 activities, this includes logins and other non-dataverse table related activity. Again a lot of junk has to be exported with real data.
3. We have 81 environments that can log table activity into the compliance centre.
There is no way to filter and separate out specific environments.
4. We want to look at activity on specific tables but there is no filter that allows this.
5. We want to look at specific record activities CRUD but there is no filter for this.

Not the most helpful of data structures. This is a one record table create

{"CreationTime":"2021-12-06T20:33:11","Id":"f8aa0752-036e-4af0-a026-01be0d0b3bbf","Operation":"CrmDefaultActivity","OrganizationId":"f67feaf5-3c41-44ef-8bae-64792f501e0a","RecordType":21,"ResultStatus":"Success","UserKey":"10032001B571C736","UserType":0,"Version":1,"Workload":"CRM","ClientIP":"119.151.198.139","ObjectId":"Create crec0_vessel","UserId":"prince.charles@tack.co.uk","CrmOrganizationUniqueName":"org44de3f34","Fields":[{"Name":"crec0_tonnage","Value":"44444"},{"Name":"crec0_length","Value":"300"},{"Name":"crec0_ship","Value":"BigShip"},{"Name":"crec0_captain","Value":"TopCaptain"},{"Name":"crec0_name","Value":"1006"},{"Name":"crec0_vesselid","Value":"01441cb4-d356-ec11-8f8f-000d3aa9d062"}],"InstanceUrl":"https:\/\/tt8.crm4.dynamics.com\/","ItemType":"Dynamics365","ItemUrl":"https:\/\/tt8.crm4.dynamics.com\/main.aspx?etn=crec0_vessel&pagetype=entityrecord&id=01441cb4-d356-ec11-8f8f-000d3aa9d062","UserAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/96.0.4664.55 Safari\/537.36 Edg\/96.0.1054.41","CorrelationId":"00000000-0000-0000-0000-000000000000","EntityId":"01441cb4-d356-ec11-8f8f-000d3aa9d062","EntityName":"crec0_vessel","Message":"Create","PrimaryFieldValue":"","Query":"","QueryResults":"","ServiceContextId":"00000000-0000-0000-0000-000000000000","ServiceContextIdType":"","ServiceName":"Dynamics365","SystemUserId":"68d4ad99-6853-ec11-8c62-002248811e29","UserUpn":"prince.charles@tack.co.uk"}
Category: Dataverse
STATUS DETAILS
New