You have an Azure subscription named Subscription1 that contains an Azure Log Analytics workspace named Workspace1.
You need to view the error events from a table named Event.
Which query should you run in Workspace1?
Table scoping: To search a term in a specific table, add in (table-name) just after the search operator:
Search in table Event: search in (Event) "error"| take 100
Search in multiple tables: search in (Event, SecurityEvent) "error"| take 100