Log Analytics Data Dictionary

Copper Contributor

Is there a way to list the tables eg (Alert, Event, Perf, ...) as you would with a relational database by querying a data dictionary?

3 Replies

A command like that does not today exist, but is fairly easy to replicate with the following (somewhat computationally expensive) query:

union withsource=tblName * 
| distinct tblName

Thanks,

-Evgeny

Here is another method to see all data types and how many records in each:

search * | summarize count() by $table
search * | distinct $table will return all the tables you have available.