Managing queries
Note
This feature is in the Preview stage. To get access, contact tech support
This section describes how to create, manage, and run KQL (Kusto Query Language) queries.
Creating a new query
To create a new query:
- Open an investigation.
- Click New query.
- In the query editor, enter a KQL query or select a template.
Tip
Use the tooltip in the editor: Enter a query using KQL syntax, or select a template query.
Editing a query
To edit a query:
- Open an investigation with the required query.
- Select the tab with your query.
- Make your changes in the query editor.
Changes are saved automatically.
Selecting a period
To select a period for your query:
- Click the period selector next to the start button.
- Select one of the presets:
- Last 5 minutes
- Last 30 minutes
- Last hour
- Last 3 hours
- Last 6 hours
- Last 12 hours
- Last day
Or select a custom period:
- Click the time period selector.
- Select a custom period.
- Specify the start date and time of the period.
- Specify the end date and time of the period.
- Click Apply.
Running a query
To run a query:
- Make sure your query is entered in the editor.
- Select a time period.
- Click the query run button.
After you run it, the query enters the Running status. Once it is over, its results are presented in the table and on the histogram.
Stopping a running query
To stop a running query:
- While the query is running, click the stop button.
- The request will enter the Canceled status.
Renaming a query
To rename a query:
- Click the query name in the tab.
- Enter a new name.
- Press Enter or click outside the input field.
Deleting a query
To delete a query:
- Right-click the query tab.
- Select Delete.
- Confirm the deletion.
Warning
Deleting a query is irreversible. The results and execution history will be deleted.
Sharing a query
To share a query:
- Open the query.
- In the actions menu, select Share.
- Copy the query link.
This link contains the query text and the selected period. The recipient will be able to open the query in their investigation.
Customizing the fields displayed in the results
To customize the fields displayed in the results table:
- Run the query.
- In the results table, click the column settings icon.
- Select the fields you want displayed.
- Reorder the fields by dragging and dropping.
- Click Apply.