- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
11-30-2023 11:01 PM
How can I get callout values in front of the row (count Example:1478)like below for a graph while creating an Xql query in Cortex XDR?
12-05-2023 07:40 AM - edited 12-05-2023 07:51 AM
Hi Kavurisowmya,
You may try this query using the dataset=alerts which will provide a list of alerts that are only a part of an incident. You may also filter by the desired Actions:
dataset = alerts
| fields alert_id, incident_id, severity, alert_source, action
| filter incident_id != null // only show alerts that are part of incidents
| filter (action != N_A)
You may also use top stage to return the approximate count as shown in your screenshot:
| top action top_count as Alerts, top_percent as Percentage_of_XDR_Agent_Alerts
| alter Percentage_of_XDR_Agent_Alerts = divide(to_integer(multiply(Percentage_of_XDR_Agent_Alerts, 100)), 100)
Please note that XQL training is available in Beacon:
If you found this answer helpful, please select Accept as Solution.
Thank you
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!