Report for all tickets opened in last 12 months that were opened for longer than 2 weeks

Brent Cox
Giga Guru

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? 

5 REPLIES 5

AndersBGS
Tera Patron

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.