Queries for the Usage table
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for