Power Platform Community Forum Thread Details

Hi folks,

I wants to reduce the size of both asyncoperation and workflowlog. So before the delete i wants to know the purpose of these two tables and what type of entries(data) were inserted into these entities. what logic behind these tables to store information and what kind of information it was?.

Categories:

Microsoft Dataverse with Power Apps

Hi @Anonymous,

asyncoperation table are any logs produced by jobs running on the Dataverse async servers, so these are things like async plugins, rollup columns calculations, async/background and reoccurring workflows, bulk deletion jobs, invocations to Azure service bus/functions/web hooks, etc. These logs are visible through the System Jobs page.

workflowlog table are only execution logs relating to classic workflows (not Power Automate). They are used to see what occured (success or error) when open an instance of a workflow. These log are visibible through workflows screen "Process Sessions":

It is safe and recommended to clean those up. Ensure to clean only the completed (succeeced, cancelled or failed) ones. You can also look at emails attachments, notes attachments, plugin trace logs and other custom logging that consume a lot of space over time.