Generate the report of incident which is to be breach in next 5 days

suuriya
Tera Contributor

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

2 REPLIES 2

Rajesh_Singh
Kilo Sage
Kilo Sage

@suuriya  try this - 

  1. Choose Report Type: Select List as the report type.

  2. Choose a Table: Choose Incident [incident] as the table to report on.

  3. 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 or SLA 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&colon;gs.endOfToday()

Note: This condition will include all incidents that are about to breach within the next 5 business days.

  1. Choose Columns: Select the fields you want in the report, which are Assignment group, Assigned to, Number, Business time left, and Pause 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.

  1. Group By: If you wish, you can group your incidents by Assignment Group or another field for easier readability.

  2. Run the Report: Once you have your conditions and columns set, click Run to run the report

If you found my response helpful or applicable, please consider marking it as correct or helpful to assist others who may be seeking the same information.

---------------
Regards,
Rajesh Singh

Devender Kumar
Tera Guru
Tera Guru

Hi suuriya,

Please refer the below link.

https://www.servicenow.com/community/platform-analytics-forum/create-report-for-incidents-that-will-... 

 

https://www.servicenow.com/community/itsm-forum/how-do-i-highlight-an-incident-where-the-sla-breache... 

 

If this resolved your issue, please don't forget to mark my answer as correct or helpful.

Regards 

Devender