Table Sizes

Question

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

clivewatson · Answer

superjay&nbsp;
SigninLogs
| summarize count(), MBytes = sum(_BilledSize) / (1024*1024)
&nbsp;

count_
MBytes

325
1.4729270935058594

&nbsp;
&nbsp;

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

superjay · Answer

Thanks Clive! Works great!

revanth1 · Answer

superjay&nbsp;Instead you can use&nbsp;Signinlogs|summarize Total=sum(estimate_data_size(*))|project format_bytes(Total)

Forum Discussion

Table Sizes

3 Replies