NOTE: The Query Builder is currently available in "preview" form
A feature that is in "preview" has made enough progress to be suitable for customer use, albeit still in active development.
InsightVM customers can take advantage of this preview to provide early feedback and usage data that will shape the final version of the Query Builder when it becomes Generally Available (GA).
Like other preview features, the Query Builder may not yet have all the functionality planned for the GA version and may only be accessible from cloud-enabled pages in InsightVM,such as the Dashboard tab. Using this preview will not affect your production data.
The following features are not yet available in the preview, but are planned for GA:
- Result table column customization
- Additional table columns
- Individual tabs for Software and Services data
- Query filter inheritance in Asset and Vulnerability detail pages
- Integration into Dashboard Cards and Remediation Projects
The Query Builder is a cloud-based feature that helps you distill asset and vulnerability data using custom-built queries. These queries are composed of “pills”, which are individual criteria that filter your data based on an array of unique parameters. These pills display and define the fields, operators, and values as the query is built.
The Query Builder allows you to query and analyze data without the need to understand SQL syntax or use third party tools. Future functionality will include the ability to take immediate actions to create Goals, Automations, or Remediation Projects - all within the Insight platform.
You can use the Query Builder to:
- Quickly pivot between Asset and Vulnerability results using the same query.
- Perform faster queries than those conducted with the Security Console.
- Export data to a CSV file.
To access the Query Builder, sign in to your Insight platform account and open your InsightVM product. In the upper right corner, click the icon with the magnifying glass next to the account icon.
Before building a query, let’s familiarize ourselves with the interface and learn some basic concepts.
Click Add Criteria to open the field selection interface.
A. Click Suggested Fields to display the most commonly used fields and their definitions.
B. Click Recent Fields to display fields that you have recently used in other pills.
C. Under Categories, you’ll see a list of field categories. Click a field category in the left panel to automatically scroll to the relevant fields in the second panel (denoted in this figure as C-1). You can also scroll through the fields manually. Each field definition is located to the right of its corresponding field label.
Type a keyword in the search bar to quickly bring up fields that contain that keyword.
D. Click the desired field to add it to your in-progress query (denoted in this figure as D).
E. Next, select an operator from this panel.
F. Finally, select a value from the available list in this panel or enter one manually.
G. Click Apply Criteria to create the pill.
Let’s take a closer look at the structure of the pill.
A. Filter checkbox - Check this box to apply the contents of the pill to your data. If you uncheck the box, the pill will not apply to the data.
B. Field - This is the attribute used to sort your data.
E. Criterion - The entire contents of a pill. The criterion can be used by itself as a query, or used in conjunction with others to make a more targeted query.
F. “X” - Removes the pill.
You can create two types of queries with the Query Builder:
- Single pill queries
- Multiple pill queries
To create a single pill query, follow these steps:
- Click Add Criteria.
- Select a category.
- Select a desired field from the field panel.
- Select an operator.
- Click Apply Criteria to complete your pill.
- Click Save to build your query.
To build a more targeted query, you can build a query composed of several pills:
- After creating the first pill, Add Criteria and build another pill.
- Chose between AND or OR to join your queries together.
You can switch to AND or OR at any time, but your choice will apply to the rest of your query. You cannot mix AND or OR pills together in the same query.
- Click Save.
Upon clicking Save, a review screen will appear prompting you to enter a query name and set the visibility.
Select Private to limit those who can see, run, and save a copy of the query to one or more users of your choosing. Included users can edit the pills to generate new results, but they cannot save changes unless they save a new query. Use the dropdown to specify which users will have access to this query.
To load a previously saved query, follow these steps:
- Click the Load Query button in the upper right corner of the Query Builder interface.
- Select the desired query.
The current visibility permissions of the query will affect the way you can edit existing queries and save new copies:
- If you are the query owner, you can edit the query and save as-is.
- If a colleague shared the query with you, you must save your changes as a new query. Click the following icon to save a query as a new copy:
For easy reporting, you can export query results as a CSV file. Click the Export as CSV button to download a CSV file with the contents of your currently applied query.
As mentioned before, new functionality will be added to the Query Builder soon.
Upcoming features include:
- Additional columns for solutions, software, and services
- Column customization functionality to help you find the information you’re looking for
- Quick pill application through inclusion/exclusion functions on individual table cells