Creating Queries Using Filters
  • 13 Jun 2022
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Creating Queries Using Filters

  • Dark
    Light
  • PDF

You can create and save queries in two modes.

This page explains how to create queries for Activity Logs and Adapters Fetch History using filters.
Use these queries to easily view data about the running of the system. Once you create a query using filters you can save it and use it like any other saved query in the system. Learn more about viewing and saving queries on Queries Page and Saved Queries
Filters and Search structure are very similar on the Adapter Fetch History and Activity Logs pages. The filters and searches that you run can be saved like any other query and be reused and retrieved from the Query page.

Creating the Queries Using Filters

  1. Set filters on the page you are interested in, for instance on the Log Activity page, or set a search.

NewActivityLogUp.png

  1. Click Save As; the Save As Query dialog opens.

SaveASaSimpleQueryN1

  1. Set a query name and description.
  2. Set Tags if required, refer to Tags in Saving a New Query
  3. Select a folder in which to save the query, by default the Shared Queries folder is selected. Note that these queries can only be saved as public queries (not private queries), and can therefore only be saved in folders which are public. Learn more about working with folders.
  4. Save the Query.

The Query now appears on the Queries page.

Loading a Saved Query

You can find and load the queries that you saved from the Queries page.

Copying a Query

You can copy a query.
Once you configure filters or a Search and saved them as a query, an arrow appears next to Save As.
To copy the query, click the arrow and choose Copy Query Link.

CopyQueryLinkN.png

  • You can only copy query links for a saved query (not an edited query.

Updating Query Details

Once you configure filters or a Search and saved them as a query, an arrow appears next to Save As.
Click the arrow and choose Update Details to change any other query details, such as the name, description, tags and folder where it is saved.

Queries created using filters can be used as queries in the following basic enforcement set actions: Send Email, Send to Syslog Server, Send to HTTPS Log Server, Send Slack Message and Push System notification. In this way you can set the system to send the results of a specific query to a certain destination.

Note:

The following actions will send JSON and not tables



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.