Home

Log Analytics Data Dictionary

Mike Westaway
Regular Visitor

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies