Creating Queries Using Filters
  • 26 Jun 2023
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Creating Queries Using Filters

  • Dark
    Light
  • PDF

Article Summary

You can create and save queries in two modes.

This page explains how to create queries for Activity Logs, Adapters Fetch History and Asset Investigation 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, Activity Logs pages and Asset Investigation. 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.

Using Activity Log, Adapter Fetch History and Asset Investigation Queries in Enforcement Actions

Queries created using filters can be used as queries in the following basic enforcement set actions:

In this way you can set the system to send the results of a specific query to a certain destination.

Note:

These actions will send JSON files and not tables



Was this article helpful?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
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.