Jump to content

Recommended Posts

Posted

Hi

I'm looking to do some analysis on the average amount of time a type of request spends in a given team.

Is the time spent data from Request Insights stored in a table somewhere?

The h_itsm_request_team_assignment table has the h_assignment_timestamp column which tells us when the request was assigned to that team. Would it be possible to add a column which captures the timestamp for any forward assignment?

Many thanks

Mosh

Posted
13 hours ago, Mosh said:

The h_itsm_request_team_assignment table has the h_assignment_timestamp column which tells us when the request was assigned to that team. Would it be possible to add a column which captures the timestamp for any forward assignment?

That would be stored in the next entry with the same Request Reference.

Posted
10 minutes ago, Steve Giller said:

That would be stored in the next entry with the same Request Reference.

Thanks Steve I did notice that but it isn't easy to do analysis like this.

I'll assume from your response that the answers to both my questions is no.

Posted
6 minutes ago, Mosh said:

I'll assume from your response that the answers to both my questions is no.

I'm not saying no to the first one, it's not something I've needed to look into so I don't know whether that data is stored somewhere or calculated when you view it.

Posted
7 hours ago, Steve Giller said:

I'm not saying no to the first one, it's not something I've needed to look into so I don't know whether that data is stored somewhere or calculated when you view it.

I would be very grateful if I could get an answer to this - would be very helpful. Thanks Steve

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...