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