Saved Queries
  • 13 Jun 2022
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Saved Queries

  • Dark
    Light
  • PDF

Once you create a new query, or update an existing one, you can save the query and add it to the Saved Queries list for future and advanced use. Saved queries are also used in Enforcement Sets, Dashboard Charts and Reports.

QuerySAveEG(2)

Saving a New Query

The Assets pages display the query name above the search bar along with the query status. The query status indicates whether this is a new query that is unsaved, or a saved query that has been edited.
To save a new unsaved query:

  1. Click Save As next to the query name; the Save as a New Query dialog opens.

SaveasaNEwQueryN2

  1. Set the Query name

  2. Set the Query description (optional)

  3. Tag - Choose a tag from the drop down list of tags available in the system, or start typing to add a new tag. When you add a new tag, click Add New to add the tag to the system. Use Clear All to remove a tag you selected. Tags help organize your queries. You can add a tag to a query when you create the query, as well as from the Saved Queries page. The list of tags used in queries is the same across the whole system.

  4. Private Query – Select Private Query if you want the query to be available only to you. A saved query can have private or public access. Private saved queries are only visible for the current user. Public saved queries can be viewed by all users and can be accessed everywhere in the system (Dashboards, Enforcement Center, Reports, Query Wizard).

  5. Select the folder where you want to save the query. The folders available depend on whether the query is private or public. By default public queries are saved in the Shared Queries folder and private queries are saved in the My Private Queries folder.

  6. Choose Save

Note:
The permissions: Create saved query, Edit saved queries, Run saved queries and Delete saved query - All apply on public saved queries only. Private saved queries can always be created, edited, run and deleted.
Note:

If you have written a query in AQL using terms or expressions not supported in the Query Wizard, when you save the query the system informs you that the system will save the query as an AQL expression.

When you save a query, you save the following:

  • Query filter – the collected devices together with their details according to the filter set.
  • Query view – The columns that are displayed when you save the query are saved as part of the query and used to display the same “view” of selected fields in the table every time you use this query. Set the columns in Edit Columns.
NOTE
The “view” is saved as part of the saved query. It doesn’t impact the filtered devices data - only the data that is visible in the query results table.

Running a Saved Query

Once a query is saved you can run it from the Queries page, from the Saved Query drawer or from the Saved Queries list in the Query Search Bar.

Saved Queries List in the Query Search Bar

In an Assets page, click the Query search bar. The drop-down list displays a list of saved queries and history of the queries run in Axonius.
To run a saved query, use the vertical scroll to select the saved query you want. Then click it to run the query.

Saved Searches.png

Updating an Existing Saved Query

After you open a saved query on an Assets page, you can do the following:

  • Rename a saved query with a single click.
  • Save - Update the saved query you are working on.
  • Save as - Save the query results as a new saved query.
  • Discard Changes - Undo any changes made on the saved query you are working on and reload the saved query.
  • Reset - Reset the page to its default column view and with no filtering, resulted in all devices/users being displayed.
  • Copy Query Link - Click the copy Query Link icon from the Saved As drop down CopyLinkonmain bar.png to copy the link to the query and then share it with others.

QuerySAveEG(2)



What's Next
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.