Queries for the DCRLogErrors table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Ingestion and Transformation errors from data collection rules

Retrieves logs indicating ingestion and transformation failures during logs ingestion using data collection rules.

// This query helps list the most recent 10 logs for failures during log ingestion/transformation. 
DCRLogErrors
//| where OperationName == "Ingestion" // Uncomment this line to see Ingestion errors
//| where OperationName =="Transformation" // Uncomment this line to see Transformation errors
| sort by TimeGenerated desc
| limit 10