Log Analytics uses KQL – Kusto Query Language – as the query language for the log storage. On the past, we could only save the queries in the Log Analytics Workspace and it was not easy to share them
The new feature to change this scenario is the Log Analytics Query Pack. This feature is an object capable to contain the queries we would like to save. Log Analytics Workspace can read the queries in the query pack.
This feature is still in preview. Some details will seem to be incomplete, but there is no doubt this is an important feature
Default Query Pack
If you ignore the query packs, the query packs will ignore you. Log Analytics creates the default query pack automatically the first time you save a query. This will happen for each subscription.
Saving Queries
When you build a query you can Save a query or a function, the process is slightly different. The functions can be saved only in the workspace, not in a query pack. Let’s keep the focus on the query.
When you build a query you can save it to a query pack. You have the option to save on the default query pack or choose a query pack to save it.
If we are saving the query to the default query pack the entire process can be transparent. We save the query and all workspaces on the same subscription are able to see the query.
On the other hand, if we are using custom query packs we should use the Tags carefully, so we will be able to find the queries easily on the Logs UI.
There are 3 types of Tags we can use on our queries, they are:
Category: The Category Tag is also used by the example queries provided by Microsoft to classify the purpose of the query. We can fit the query in the existing categories or create our own.
Resource Type: The idea of this tag is to classify the queries by the type of resource they are using. However, my recommendation is to use this tag to classify the queries by Query Pack in which it’s saved. The UI doesn’t provide in a very good way the information about the source query pack. It’s up to us to use the Tag fields to classify by query pack.
Label: This is a more “open” Tag field, you can use this for many different purposes. However, this field is not included (at least not yet) in the Filter or Group By UI options explained further on this blog. Due to this, I don’t recommend the use of the Label to classify by query pack.
Reading Queries
The Logs UI, when we select the option on a Log Analytics Worskpace, show us two windows: One popup window, displayed first, allowing us to select a query to edit or execute, it’s like an introduction window; The main query building window, which will display existing queries and allow us to build new ones.
On the popup window, a new option was included allowing us to select the query packs we would like to see on the query editor. The Log Analytics Workspace will remember our selection, so usually we may need to make this selection once, unless the need of additional queries or functions appear.
On the UI, after selecting the query packs, you can close this window and even so your selection will still be remembered.
On the main query editor window, the information about the query pack is displayed only in two different places:
Group by option: The Group by option to group the queries has the option to group the queries by the query type. There are two main query types: “Example Query”, the examples provided by Microsoft and “Query Pack” queries, the queries saved in query packs, either the default or custom ones.
This option can tell you what queries are from query packs, but it doesn’t break down the queries by query pack. In order to achieve this you would need to use the Tag together the group by, as explained before.
Query Popup: Each query has a popup window displayed when we select the query. This popup window tell us the source of the query. It’s useful for individual queries, but to find the queries from one query pack, for example, we would need to look query by query. We avoid that using the Tag to Filter or Group the queries by query pack, as mentioned before.
Summary
Log Analytics is a very important feature on Azure and can be used even for on premises implementations. The Query Packs expand the possibility to create reusable KQL queries and spread Log Analytics culture on an enterprise level
References
- Log Analytics and Azure Data Studio: New Extension
- Creating Kusto sub-queries
- Creating functions in Kusto Queries
The post Saving and Sharing Log Analytics Query appeared first on Simple Talk.
from Simple Talk https://ift.tt/9Cj1Xzd3t
via
No comments:
Post a Comment