Row count for all tables

[Scott Allison]

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 · Accepted solution]

I think you are looking for this query: 

search * | summarize count() by $table

Hope it helps,

Meir

[#3]

This is perfect (and so simple). Thanks!