KQL Search

Query Details

HomeAI ToolsDevice Query

Solution Data Usage

Query

//Monitoring data usage by solution. Produces a piechart

Usage 
| where TimeGenerated > startofday(ago(31d))
| where IsBillable == true
| summarize TotalVolumeGB = sum(Quantity) / 1000. by bin(TimeGenerated, 1d), Solution
| sort by TotalVolumeGB desc
| render piechart

Explanation

This query is used to monitor data usage by different solutions and display the results in a pie chart. It filters the data for the last 31 days, considers only billable data, calculates the total volume in gigabytes, groups it by day and solution, sorts the results in descending order, and finally renders a pie chart.

Details

Rod Trent profile picture

Rod Trent

Released: November 5, 2021

Tables

Usage

Keywords

Monitoring,Data,Usage,Solution,TimeGenerated,IsBillable,TotalVolumeGB,Quantity,render,piechart

Operators

|where>startofdayago31d==truesummarizeTotalVolumeGBsum/1000.bybinTimeGenerated1dSolutionsortdescrenderpiechart

Actions