Queries for the Usage table

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

Usage by data types

Chart the amount of logs reported for each data type, today.

Usage
| summarize count_per_type=count() by DataType
| sort by count_per_type desc
| render piechart

Billable performance data

Calculate the volume of billable data (in GB) for Perf data, over the last day.

Usage
| where TimeGenerated > ago(1d)
| where IsBillable == true
| where DataType == "Perf"
| summarize TotalVolumeGB = sum(Quantity) / 1024

Volume of solutions' data

Chart the volume of data (in Mb) sent by each solution.

Usage
| summarize total_MBytes=sum(Quantity) by Solution
| sort by total_MBytes desc nulls last
| render barchart

Total workspace ingestion over the last 24 hours

Volume (GB) of all data ingested to this workspace, over the last 24 hours.

Usage
|where TimeGenerated > ago(24h)
|summarize TotalIngestionVolGB = sum(Quantity)/1024.0

Container Insight solution billable data

See total billable data from Container Insights solution.

//This includes billable data for all solutions in the workspace, see for Container Insights solution
Usage
| where TimeGenerated > startofday(ago(30d))
| where IsBillable == true
| summarize TotalVolumeGB = sum(Quantity) / 1000 by bin(TimeGenerated, 1d), Solution
| render barchart