How to get a list /report of all open incidents at the end of day?

njsamuel
Tera Contributor

‎10-10-2023 10:37 AM - edited ‎10-10-2023 10:38 AM

I would like to get a report of all the open incidents everyday for 11:59pm. The query that I'm using on the incident table is below. I just don't know or can't figure out how to get that at 11:59pm instead of manually running it at 11:59 pm which isn't an option. And, no we don't have performance analytics. 

Not worried about when it was opened, I just need to know if it was resolved/closed or not!

njsamuel_0-1696959358703.png

 

0 Helpfuls
  • 1,598 Views
7 REPLIES 7

Anubhav24
Mega Sage
Mega Sage

‎10-10-2023 10:39 AM - edited ‎10-10-2023 10:59 AM

HI @njsamuel ,

You can use scheduling of reports.

https://developer.servicenow.com/dev.do#!/learn/courses/utah/app_store_learnv2_reportanalytics_utah_...

 

Please mark helpful/solution if response was helpful

0 Helpfuls

njsamuel
Tera Contributor
In response to Anubhav24

‎10-10-2023 12:01 PM

I've scheduled a report to run tonight to capture this data. We'll see how this goes and if the data makes sense based on query. Thanks for the suggestion!

0 Helpfuls

Anubhav24
Mega Sage
Mega Sage
In response to njsamuel

‎10-17-2023 07:47 AM

Hi @njsamuel , did it help you or resolved your problem.

0 Helpfuls

Harsh_Deep
Giga Sage
Giga Sage

‎10-10-2023 11:01 AM

Hello @njsamuel 

 

In the filter navigator open Reports > Scheduled Reports. Click the New button to create a schedule.

Configure the scheduled report.

  • Name: Descriptive name of schedule.
  • Report: Select a report to schedule from the choice list.
  • Users: ServiceNow users who receive the notification.
  • Groups: ServiceNow groups that receive the notification.
  • Email addresses: Comma-separated list of recipients' email addresses.
  • Active: Enable/disable the schedule.
  • Run: The frequency to run the report and send notifications: Daily, Weekly, Monthly, Periodically, Once, On Demand, Business Calendar: Entry Start, and Business Calendar: Entry End.
  • Time/Day/Hours/Repeat interval/Starting/Business Calendar/Offset type: These fields are available on the form only for certain Run values and are used to specify when to run the schedule. Time values are specified using a 24-hour clock.
  • Subject: Text for the subject line of the notification.
  • Type: Choose a format from the choice list for the report.

If my answer solved your issue, please mark my answer as Correct & Helpful

0 Helpfuls