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

Dear @Venu Gopal Krishna VV ,

You can use the default functionality using the workbooks in Log Analytics workspace:

This will result in a report looking something like this (beware of the TimeRange filter):

If you want to query the data using Kusto, you can select the query button on the top right:

To get the top 10, you will need to edit the query to:

union withsource=['Table Name'] *
| summarize Entries = count(), Size = sum(_BilledSize) by ['Table Name']
| top 10 by Size desc
| project
    ['Table Name'],
    ['Table Entries'] = Entries,
    ['Table Size'] = Size,
    ['Size per Entry'] = 1.0 * Size / Entries

Also here: beware of the TimeRange filter!

Hope this will answer your question.

Kind regards,

Wilko

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".