How to see the pending time of all the tickets?

[Limitless]

Hello,

I need to find a way to see the pending time for all tickets, of all agents, if there is a way to filter by queue or name of the agent this it will be great also.
I have admin rights.
Thanks in advance for your answers.

[crythias]

you might do this from a sql query or simply use the search function.

[Limitless]

Maybe is something that i miss but i cannot find a way to see the pending time using the search function, you refer to the search found under the Tickets menu i suppose, no?

[Duren]

I have been looking at this today. I cannot see anything in the standard search to show Pending Time. I need to get this into a CSV report or something. I attempted to adjust the Ticket::Frontend::AgentTicketSearch###SearchCSVData and browsed through the fields on the SQL database.

Any clues how I could A) add it to the search functionality on the standard search and B) add it to the CSVData for export so that I can run reports on it.

Thanks for any help!
Duren

[crythias]

My apologies for the incorrect information.

The pending time is called "until_time" and is an epoch number in the "ticket" table.
unfortunately, no TicketSearch appears to return this information, though it would be available from sql searches, which can export to csv.