CA Service Management

Good morning I want to know how I can consult
The time that a ticket lasts in each state

Hi John Jairo Sierra Garcia,

When you are referring to "state" - can you tell us specifically what field you are referring to?

Since we dont track how long a certain field has a certain value within the product, typically to do something like this, you would need to look at the activity history and look at when that field was updated to a certain value on the ticket, and then when it was updated again to a different value, and then calculate the timing difference.

Let us know what field you are looking for specifically.

Thanks,
Jon I.

Thank you, if the idea is know how long was a ticket waiting for the user and how long it took to get resolved

Your requirement sounds similar to an enhancement request already submitted - Total time spent in each status 

I see the information kpi ticket datatable if it is already active

You need to search  the alg object.

Or

You can customize the action to split the information.

how would it be?

Activate the kpi ticket data table.

Searching in alg object is not reliable since the System messages can be lost if a user inputs a comment.