All Open Tickets Age

All Open Tickets Age

hi guys,

i was looking for a report to show open tickets age, im running MSSQL and build # 9018

example below:


ID                  Status                     Age             technician
11                  open                        20                  tech 1
232                on hold                    10                  tech 2
324                open                        11                  tech 1
4234              waiting vendor        30                  tech 3