Managing Queries
Queries in LogScale are written in the Query editor available from the page (top of the User Interface). The queries can also be saved and reused from the User Interface.
Writing a New Query
The Query editor is fully editable and you can enter single and multiple-line queries. For a comprehensive list of LogScale's query functions with descriptions, see Query Functions.
To write a new query in LogScale:
Go to
page and click on the repository or view in which you want to search.From Query editor and press Enter or click .
, enter one or more search terms in theIf needed, adjust the size of the query editor by dragging manually or clicking the small
arrows on the right to make it fit the query.
Here is an example of very simple search with just one value:
Figure 82. One-Value Search
The Query editor contains a query, and the search results appear in the Event list in the Results panel.
In the example, we are filtering by selecting only events that contain
the text example.com
anywhere in their log
message.
This is essentially the same as using grep on the Unix command-line, except with LogScale User Interface you can do it across all the logs, and from all servers and services at once.
Taking this example a little further, when we add a second search term
to display only results for proxyRequest
, the results are
further filtered:
Figure 83. Two-Value Search
For much more details on the possible operations you can perform with queries, see Common Queries.
Saving Queries
You can save a query for future use — you save the query, not the resulting data.
In the Results panel click (upper right corner) and select the option.
In the appearing Save query dialog box, specify whether this query is overwriting an existing one, enter a name for the query (required), and then click .
You can find and reload saved queries from the Queries dropdown anytime later. From the Saved page under Queries dropdown you can also mark that query as favorite, export it as YAML, edit or delete it.
Do the following:
From the Queries dropdown at the top of the User Interface (above the Query editor), click the Saved page and then select the relevant saved query.
You can make a saved search load automatically when opening the repository.
Note
You will be able to see all saved searches in the repository or view you are granted access for (via the
Data read access
permission).Figure 84. Saved Queries
Hovering a saved query and clicking
allows you to mark that query as favorite, export it as YAML, edit or delete it.You can also save a query you use often by creating your own syntax function. See User Functions (Saved Searches) for more information.
Recalling Queries
You can recall recently run queries or saved queries from the Queries dropdown at the top of the User Interface (above the Query editor) anytime later.
From the Queries dropdown, click the Recent page and then select one of the recent queries or click the Saved page to select a saved query.
Figure 85. Recent Queries
Using Saved Queries in Interactions
You can use saved queries to save interactions on the Event List Interactions and Manage Dashboard Interactions.
page, thus avoiding recreation of the same interaction at every search. For more information on the interactions LogScale support, seeYou can either:
Load a saved query with interaction from Queries dropdown and clicking the Saved page (or pick a saved query from a package):
Figure 86. Loading a Saved Query
Make an interaction from a query you have created and save it in a new saved query — or save your interaction in an existing saved query.
From the Results panel click and select the option to open the Save query dialog box, where you save your query along with the interaction you have created.
Figure 87. Interaction with a Saved Query