Skip to main content

Privacera Platform master publication

Reports with the Query Builder

:

With the Query Builder, you can create reports using Privacera-supplied and custom filters.

There are two types of queries:

  • Privacera-supplied: Dropdown menus to specify values of fields that must be included in the search results.

  • Query Filters : Allow you specify fields that must or must not be included in the search results.

Access the Query Builder

To access the Query Builder, follow these steps:

  1. From the navigation menu, select Reports > Built-in Reports.

  2. Select View or Edit Report to open either Data Discovery Overview or Discovery Alerts.

    The Query Builder page is displayed.

The Privacera-supplied filters are shown at the top. Search results are displayed at the bottom.

From left to right across the top:

  • Partial or full match of the data

  • Dropdown menus to search by Application, Tag, Datazone, or to exclude a certain resource.

  • Search by location.

  • Search only the last seven days.

  • Scan type: either Offline or Realtime.

  • Group Folders in the output.

  • Group Tables in the output.

Available filters

The following filters are the basis for both the Privacera-supplied search and custom Query Filters.

Filter

Description

Application

The application running on the asset, such as a web server or database.

Tags

User-defined information fields you have applied to assets.

Tag Attributes

Additional criteria on those tags to further refine the information.

Datazone

Your logical grouping of the assets by type or security level of the data

Datazone Owner

The registered user or group that manages that datazone

About the Scan Type filter

The Scan Type dropdown menu has the following selections:

  • Offline: The report is based on the most recently stored data collected from the assets by Privacera.

  • Realtime: The report is based on data collected from the assets at the time the report is run. Depending on the number of assets you have, network latency, and other considerations, generating a realtime report might require that you be patient for the results.

Use the Query Builder

This is a general approach to using the Query Builder. As you become more familiar with the tool, you will refine this general approach for your needs.

Prerequisites:

  • Be sure you have a good understanding of the types of information you have associated with your cloud-based assets: the applications, tags, datazones, and other categories. See Available filter fields.

  • Decide on the fields that will display the information you want to see. For instance, are you interested in the applications or the datazones or both?

To use the Query Builder, follow these steps:

  1. From the dropdown menus on the Query Builder page, select the fields you want to see.

  2. As you make selections, total counts of the assets in various categories based on your selection criteria and the complete results of the search are dynamically displayed.

  3. Look at the output to determine if you have the data you want to see. You can adjust the menu selections to further refine the results. You can also use Query Filters to tailor the output to your needs.

Save or export a report

To reuse a search at a later time, click Save and enter a name for the search.

To download a copy of the resulting data in Comma-Separated Value (CSV) format, click Export to CSV and follow the leading prompts.

Create custom reports with Query Filters

Using Query Filters, you can find and view precise information about your cloud-based assets.

Conditions, filters, “Are”, and “Are Not”

You can define certain conditions to filter the data to select the assets you are interested in. These filters are listed in Available filter fields. You set these conditions as either Are applicable (the filter must match) or Are Not applicable (the filter must not match) to the assets you are interested in.

You can combine multiple conditions to further refine your search.

Enable Query Filters

To enable Query Filters:

  1. From the navigation menu, select Reports > Built-in Reports.

  2. Click View or Edit Report to open either Data Discovery Overview or Discovery Alerts.

  3. Enable Query Filters using the Query Filters toggle.

Apply Query Filters

This is a general approach to using Query Filters. As you become more familiar with the tool, you will refine this general approach for your precise needs.

Prerequisites:

  • Be sure you have a good understanding of the types of information you have associated with your cloud-based assets: the applications, tags, datazones, and other categories. See Available filter fields.

  • Decide the condition or conditions that will display the information you want to see. For instance, are you interested in the applications or the datazones or both?

To apply Query Filters, follow these steps:

  1. Enable Query Filters using the Query Filters toggle.

  2. Select Add Condition.

  3. From the dropdown menus for the condition:

    1. On the left, select the needed filter.

    2. In the middle, specify whether that filter is applicable (Are) or not applicable (Are Not) to the search.

    3. On the right, enter a string that matches what you are interested in.

    A list of matching data is displayed from which you can select the exact field. The Query Preview on the right shows a text representation of the query.

  4. Add more conditions, if required. To add another condition, specify AND to indicate that the condition is required or OR to indicate that the condition is optional.

  5. After you have added all required conditions, click Search.

    The total counts of the assets in various categories based on your filter criteria and the complete results of the search are displayed.