top 10 tables in Log Analytics Workspace

Question

Hi All,

 

i want to see the top 10 tables using more space in the log analytics work space.

need some help to fetch the top 10 tables

can anyone please help me with query which can pull the top 10 tables using more space

 

appreciate for help in this. 

Answer 1

You can get the top 10 like this:

Usage 
| summarize GBytes=sum(Quantity)/1000 by DataType 
| top 10 by GBytes 
| order by GBytes desc

Or for a Week, or other time range add:

Usage

| where TimeGenerated > ago(7d)

| summarize GBytes=sum(Quantity)/1000 by DataType

| top 10 by GBytes | order by GBytes desc