XQL query for incident report

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

XQL query for incident report

L0 Member

I like to get a hint how i can build simple xql query for  overtime timeframe for incidents. I need to filter that data, but that kind report that i can show example monthly base report for customer. where there are data for each day

2 REPLIES 2

L4 Transporter

Hello @T.Nurmi 

 

Thanks for reaching out on LiveCommunity!

To get a comprehensive view of incidents over time please use "Incident Management" dashboard where you can interact with data based on various parameters like status, severity and assignment etc. You can also generate a report of it based on the timeframe that you want to see. You can also create a custom dashboard based on "Incident Management" by adding custom widgets for your particular use case.

 

Please click Accept as Solution to acknowledge that the answer to your question has been provided.

Hi. Thanks for answer, but what i try to find is to get trend reports . example here is data for 30 days, but i like to get trend reports for this kind info> then able to see monthly report/by day

 

config timeframe between "30d" and "now"
| dataset = incidents
| filter (status in (ENUM.NEW,UNDER_INVESTIGATION ))
| filter (alert_sources != "fw")
| comp count(status) as counter by status


| view graph type = pie xaxis = status yaxis = counter

  • 317 Views
  • 2 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!