Capturing the "resolved" state for reports

[ccarson]

Hi everyone,

I am trying to run a report where i can capture the time stamp for when a ticket moves from an open state to a resolved state. I tested out some reports that included solution time, solution in Min, and Solution diffinmin, and those don't seem to be what i am looking for. The solution time stamp matches when the ticket moves to a "closed" status. Is there a way to capture the solution time of a ticket using the change to resolved status that can be generated on a report?

[skullz]

not by default..i assumed this resolved state is pending auto type ?

only can be achieved by

1. using left join SQL statement (maybe?)
- check table ticket, ticket_history, ticket_history_type. These table should contain timestamp when the state is changing.

OR

2. Custom generic agent module (perl/php). Tag ticket dynamic field with resolved timestamp when state = resolved