Forum Discussion

ScottAllison's avatar
ScottAllison
Iron Contributor
Nov 28, 2018
Solved

Row count for all tables

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!

 

Azure Log Analytics
azure monitor
  • Meir_Mendelovich's avatar
    Meir_Mendelovich
    Nov 28, 2018

    I think you are looking for this query: 

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

2 Replies

  • Meir_Mendelovich's avatar
    Meir_Mendelovich
    Icon for Microsoft rankMicrosoft
    Nov 28, 2018

    I think you are looking for this query: 

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

Resources