Show all resolved incident tickets open for more than > 7days

AAN · ‎12-20-2022

Hello,

Is there anyone familiar with how report ranges work? I am trying to show all resolved incidents that is open for more than 7 days using the incident_sla data view.

I am using the business elapsed time from incident_sla data view to detect how long the incident has been open.

See below what I have tried so far but failed, I tested resolving an incident open for 4days but still shows on my report when it should not.

AndersBGS · ‎12-20-2022

Hi AAN,

Please see the ServiceNow documentation for report ranges: https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportR...

Please also think about, that if you create the upper limit that you have created, this will both contains incident open for 7 days and incidents open for 4 days.

If you need some additional guidance, please let me know.

If my answer has helped you in resolving your requirement, please hit the thumb up button and mark as helpful.

Best Regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

AAN · ‎01-05-2023

Thank you, Anders. You've been a great help.