Table Sizes

Copper Contributor

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

3 Replies

@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

Thanks Clive! Works great!

@superjay 

Instead you can use 

Signinlogs|
summarize Total=sum(estimate_data_size(*))
|project format_bytes(Total)