topic Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard in Cortex XSOAR Discussions

Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

ansusabu — Thu, 14 Nov 2024 15:07:15 GMT

I'm in the process of creating a widget and need help retrieving details of incidents that were closed within a specific week or time frame, irrespective of their creation date. Additionally, I would like to know if there's a method to achieve this without using scripting. Could you please provide guidance on how to implement this functionality?

Re: Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

asawyer — Fri, 15 Nov 2024 00:31:13 GMT

Hi @ansusabu – Yes, this can be achieved by filtering incidents based on the closed timestamp field, for example:

closed:>="2024-11-07T00:00:00 -0700" and closed:<="2024-11-14T00:00:00 -0700"

Re: Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

ansusabu — Fri, 15 Nov 2024 10:11:02 GMT

But these values are static, right? I want the values to be changing based on the dashboard time frame.

And does your query take incidents created in during the dashboard timeframe and closed based on the query time frame? I don't want that. I want all the incidents closed during the dashboard's timeframe irrespective of their creation date

Re: Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

asawyer — Sat, 16 Nov 2024 01:36:30 GMT

Nope, you can use relative timestamps as well. For example:

closed:>="7 days ago"

To return all incidents closed during the dashboard's timeframe irrespective of their creation date, change date range of the dashboard or widget to "All times".

Re: Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

ansusabu — Mon, 18 Nov 2024 12:40:40 GMT

"7 days ago" is still static. I need the incidents which are closed from last-to-last Sunday to last Saturday every week.

Re: Query on Filtering Closed Incidents by Time Frame in XSOAR dashboard

asawyer — Mon, 18 Nov 2024 16:34:55 GMT

This can be done with reports. You can schedule the report to run every week at a particular time, like Sunday at midnight, and look back exactly 7 days from then.