Generate the report of incident which is to be breach in next 5 days
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 01:50 AM
Hi,
I have requirement to create the report to generate the incidents records which are about to breach in next 5 days.
With the following fields assignment group assigned to, number, business time left, pause time in report.
Please help me with it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 02:53 AM
@suuriya try this -
-
Choose Report Type: Select
List
as the report type. -
Choose a Table: Choose
Incident [incident]
as the table to report on. -
Filter Conditions: You need to set your conditions to identify the incidents about to breach in the next 5 days. This will depend on your SLA definitions. If you have an SLA field such as
SLA Due Date
orSLA End Time
, you can set the condition as follows:
SLA Due Date
>is
>relative
>on or after
>-5 days@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()
SLA Due Date
<is
>relative
>on or before
>@javascript:gs.endOfToday()
Note: This condition will include all incidents that are about to breach within the next 5 business days.
- Choose Columns: Select the fields you want in the report, which are
Assignment group
,Assigned to
,Number
,Business time left
, andPause time
.
Note: The Business time left
and Pause time
fields will depend on the specific SLA definitions in your instance of ServiceNow. If these fields are not available, you may need to create calculated fields or have a process in place to calculate these values.
-
Group By: If you wish, you can group your incidents by
Assignment Group
or another field for easier readability. -
Run the Report: Once you have your conditions and columns set, click
Run
to run the report
---------------
Regards,
Rajesh Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2023 02:54 AM
Hi suuriya,
Please refer the below link.
If this resolved your issue, please don't forget to mark my answer as correct or helpful.
Regards
Devender