Queries for the SucceededIngestion table

  • Article

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

Succeeded ingestions

How many succeeded ingestions accrued (per database, table).

SucceededIngestion
| parse _ResourceId with * "providers/microsoft.kusto/clusters/" cluster_name // Get the cluster name from the ResourceId string
| summarize count() by bin(TimeGenerated, 1h), cluster_name, Database, Table

Succeeded ingestions timechart

How many succeeded ingestions accrued (timechart).

SucceededIngestion 
| summarize count() by bin(TimeGenerated, 1h) 
| render timechart