Report for all tickets opened in last 12 months that were opened for longer than 2 weeks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2025 11:54 AM
Is there any way to run a report on the TASK or incident table for all tickets that have been opened in the last 12 months that were opened for longer than 2 weeks? Currently I have a filter for duration greater than 14 days, but I do believe duration is only populated once a ticket is closed. I would also like to include tickets that are still active, if possible. Can this be done?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2025 01:39 PM
Hi @Brent Cox ,
Yes, but in general you either need performance analytics or a script. as you have clearly stated yourself, this is not available OOTB as the duration is not filled for tickets that are still active.