Graph query results - Administrator Guide - Cortex XSIAM - Cortex

Graph query results - Administrator Guide - Cortex XSIAM - Cortex - Security Operations

Cortex XSIAM Documentation

Product

Cortex XSIAM

Creation date

2024-03-06

Last date published

2024-10-13

Category

Administrator Guide

Abstract

Cortex XSIAM enables you to generate helpful visualizations of your XQL query results.

To help you better understand your Cortex Query Language (XQL) query results and share your insights with others, Cortex XSIAM enables you to generate graphs and outputs of your query data directly from query results page.

Select Incident Response → Investigation → Query Builder → XQL.
Run an XQL query.
Example 125.
Enter the following query:
```
dataset = xdr_data 
| fields action_total_upload, _time 
| limit 10
```
The query returns the action_total_upload, a number field, and _time, a string field, for up to 10 results.
In the Query Results section, to graph the results either:
Use Chart Editor
Navigate to Query Results → Chart Editor () to manually build and view the graph using the selected graph parameters:
Main
Graph Type: Type of graphs and output options available: Area, Bubble, Column, Funnel, Gauge, Line, Map, Pie, Scatter, Single Value, or Word Cloud.
Subtype and Layout: Depending on the selected type of graph, choose from the available display options.
Header: Title your graph.
Show Callouts: Display numeric values on graph.
Data
X-axis: Select a field with a string value.
Y-axis: Select a field with a numeric value.
Depending on the selected type of graph, customize the Color, Font, and Legend.
Use XQL query
Enter the visualization parameters in the XQL query section.
You can express any chart preferences in XQL. This is helpful when you want to save your chart preferences in a query and generate a chart every time that you run it. To define the parameters, either:
Manually enter the parameters.
Example 126.
view graph type = column subtype = grouped header = “Test 1” xaxis = _time yaxis = _product,action_total_upload

Select ADD TO QUERY to insert your chart preferences into the query itself.
(Optional) Create a custom widget.
To easily track your query results, you can create custom widgets based on the query results. The custom widgets you create can be used in your custom dashboards and reports. For more information, see Create custom XQL widgets.
Select Save to Widget Library to pivot to the Widget Library and generate a custom widget based on the query results.