- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
09-09-2024 12:20 AM
Hi,
For our SOC report, we want to have this table with the average statistics of last week's monitoring, including average time to assign, time to respond etc. Is there a way to extract these timestamps from the incident's timeline on XQL and therefore make a custom widget? If not, what kind of bypass are there? Thanks in advance.
09-09-2024 08:48 AM
Hello @paIoaItonetworks ,
Thanks for reaching out on LiveCommunity!
Below is a reference query which you can use and build up your use case. It gives you Time to assignment of incidents and Time to resolution of incidents.
dataset = incidents
| alter TimeToAssign = timestamp_diff(first_assignment_ts ,creation_time,"MINUTE")
| alter HourToResolve = timestamp_diff(resolved_ts,creation_time,"HOUR")
| alter MinToResolve = timestamp_diff(resolved_ts,creation_time,"MINUTE")
| fields creation_time , resolved_ts , first_assignment_ts ,TimeToAssign , HourToResolve , MinToResolve
Please click Accept as Solution to acknowledge that the answer to your question has been provided.
09-09-2024 10:43 PM
There is no "first_assignment_ts" function in XQL
09-09-2024 10:51 PM
Hi,
unfortunately I also don't see the "first_assignment_ts" value in the schema and this item from this query doesn't work for me,
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!