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

Highlighted
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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 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
13 Replies