sevco.io

Configuring Actions for Saved Queries

Overview

Once a query has been saved, you can set up the following query actions from the Query Actions Panel:

  • Schedule daily or weekly emails of query results
  • Add the query to the Tracked Queries Dashboard
  • Apply tagging actions to add or remove tags from all assets in your query results


Accessing the Actions Panel

To access the Query Actions Panel, your query must be saved to either the My Queries or Org-wide Queries tab in the query builder.

  • Queries saved to the My Queries list are only viewable to you.
  • Queries saved to the Org-wide Queries list are viewable to all members in your Organization.
    • All actions applied to Org-wide queries will be visible to other members in your Organization, with the exception of scheduled query-results emails.

There are two ways to do this:

Option 1

You can save a query by selecting the Save Query button in the top-right corner of the query builder to add it to the My Queries or Org-wide Queries tab.

Clicking the "Saved Query" button


Option 2

If you've already run your query, you can save it from the Recent Queries tab. Hover over the query you'd like to save and select the Save button to add it.

Clicking the "Save" button next to a Recent Query


Once your query has been saved, you can access the Actions Panel by clicking on the from the query list and selecting its corresponding Automated Actions button.

Selecting the "Actions" link on the query builder



Scheduled Query-results Emails

Unlike other query actions, scheduled query-results emails will only be sent to the email address associated with your account. These emails can be sent on a daily, weekly, or monthly basis at a time of your choosing.

You can schedule an email by selecting the Email me query results checkbox. Next, select the edit () icon to schedule your emails

  • Select Daily, Weekly, or Monthly from the dropdown.
    • For weekly emails, select what day of the week you would like to receive your results email on.
    • Monthly emails will always default to the first of the month.
  • Specify what time you would like to receive the email at.

Once you have finished setting up your email alert schedule, click the save () icon.

Checking the Email me query results checkbox and filling out required info


To stop receiving emails, simply uncheck the checkbox.

Unchecking Email query results checkbox



Tracked Queries

ℹ️

Note: Please refer to our article on tracked queries for more information.

To add a query to the Tracked Queries page, select the Track query results checkbox.

  • Queries saved to the My Queries tab will only be visible to you on the Query Reports page.
  • Org-wide queries will be visible to all members of your organization.

Selecting the "Automated Actions" button followed by the "Track query results" checkbox


Once you've selected the checkbox, a "Tracked query successfully created" message will appear at the top of the screen to confirm that your query has been added to the Tracked Queries page.

A "Saved query action successfully created" message



Tagging Actions

Tagging Actions allow you to manage tags for assets associated with a saved query.

  • Adding a tag to a saved query will automatically apply it to any asset appearing in your query results.
  • Likewise, removing a tag or tagging action from a saved query will remove it from those same assets.

Adding a Tagging Action

Add Tags

Select the Add Tags icon (). From here, you can choose from a list of existing tags or create a new tag in the Tag name field. Add an optional tag value if desired.

Check the Remove this tag from any assets that do not match the query checkbox if you would like to remove the tag you are applying from any assets that may have previously been tagged with it that do not meet the requirements of your query.

Additionally, you can set a frequency for when the tag is automatically applied to assets by selecting the frequency edit () icon.

Once you have finished, select the Apply Tag button to add the tagging action to your query.

Adding a Tag


Remove Tags

To remove tags not associated with your saved query, select the Remove Tags icon () and search for the tag you would like to remove in the Tag name field.

Once you have finished, select the Apply Tag button to apply the query action to your query. Moving forward, the tag you've selected will be removed from any assets associated with your saved query results.

Removing a tag


Removing a Tagging Action

To remove a tagging action associated with a saved query, simply select the delete button to the right of the tag. This will tell the system to no longer apply or remove the specific tag to assets associated with your query results.

Removing a Tagging Action