SOLVED

Row count for all tables

Frequent Contributor

Good morning everyone!

 

I'm looking for a query that will return all DataTypes and their current row count. This is easy to do for individual DataTypes:

 

AzureMetrics
| where TimeGenerated < now()
| count

 

The Usage table--while useful--does not have this detail, unfortunately.

 

Any suggestions are appreciated. 

 

Thanks!

 

2 Replies
best response confirmed by Scott Allison (Frequent Contributor)
Solution

I think you are looking for this query: 

search * | summarize count() by $table
 
Hope it helps,
Meir


This is perfect (and so simple). Thanks!