Have you looked at data transformation (pre-ingestion parsing)?
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/tutorial-workspace-transformations-portal
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have set up a connection between Azure DevOps and Log analytics workspace to get the audit data as a maintenance purpose. But before storing/archiving the data, I need to follow the GDPR rules i.e I have to remove the personal data before storing it into the log analytics workspace. I need help in modifying the data before storing it in log analytics workspace.
Have you looked at data transformation (pre-ingestion parsing)?
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/tutorial-workspace-transformations-portal
I believe you can use Azure Logic App to query data from log analytics workspace and modify them based on your requirement and then send to Azure Storage. A similar sample is documented below.
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/logs-export-logic-app
Hope this helps