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

[njsamuel]

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!

[Harsh_Deep]

@njsamuel If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

[AndersBGS]

Hi @njsamuel ,

If you would like to export the report to excel, csv other format, then a scheduled report is the way to go:

If you do not want to export data, then performance analytics is the way to go to make snapshots of data.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS]

Hi @Harsh_Deep 

If my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders