Forum Discussion

Copper Contributor

Nov 10, 2020

Table Sizes

Hi all, Is there a way to view the table size, i.e. if I ran Signinlogs | count Instead of getting the number of events,I would get 120mb Thanks in advanced

azure monitor

CliveWatson

Former Employee

Nov 10, 2020

superjay

SigninLogs
| summarize count(), MBytes = sum(_BilledSize) / (1024*1024)

count_	MBytes
325	1.4729270935058594

and my workbook would do this for you https://github.com/CliveW-MSFT/KQLpublic/tree/master/KQL/Workbooks/WorkspaceUsage

superjay

Copper Contributor

Nov 10, 2020

Thanks Clive! Works great!

revanth1
Copper Contributor
Nov 17, 2020
superjay
Instead you can use
Signinlogs|
summarize Total=sum(estimate_data_size(*))
|project format_bytes(Total)