Exercise 4: Using Log Analytics
The Log Analytics service provides you with a rich UI to author and run queries. The UI supports navigation through the tables in a database and its fields. It also supports autofill to help you with KQL syntax. In the following steps, you will use the main syntax structure of the queries:
- To start querying collected data, you open the Log Analytics workspace instance or open Logs in the Monitoring section of the Application Insights instance. Close the Pick Template window if it appears and proceed to the queries.
- On the left, you will see tables such as pageViews, requests, and exceptions. You can click on a table to observe its columns. By double-clicking on a table or field, you can paste the name into the query window. You just need the name of the table to run your first query.
Figure 10.10: Application Insights query interface with tables
- Double-click on requests and get the
requestsquery. Click...
