Forum Discussion
Log Analytics Data Dictionary
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
- search * | distinct $table will return all the tables you have available.
- Meir_Mendelovich
Microsoft
Here is another method to see all data types and how many records in each:
search * | summarize count() by $table - Evgeny Ternovsky
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
