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
Highlighted
search * | distinct $table will return all the tables you have available.
Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Analytics Tab in Teams - Metrics Definition
Nealla08 in Microsoft Teams on
4 Replies
Team File Activity Reporting
GeoffGarcia in Microsoft Teams on
2 Replies
View all the Microsoft teams in the organization
Ranin Hsin in Microsoft Teams on
6 Replies
Power BI and Microsoft Teams
Diana Rimbu in Microsoft Teams on
10 Replies