yelyah.nodrog Posted March 22, 2017 Share Posted March 22, 2017 Afternoont, I have run a report for our P1's to find out the Resolve times for them. The report is as follows: The IN shows as: So it has been logged - responded to and Resolved and closed - Response time is reporting correctly however when i run a report for these figures it is showing a Resolution time of 115200 which is about 1920 Minutes, which equates to 32 hours? Now from what I can see from when it was logged to when it was resolved from the call itself it only took 5 hours 49-50ish minutes? so why on earth is it reporting as 32 hours? Please also note that @ 9.04am it was raised from a p3 to a p1 is it getting confused because of this? please help! Link to comment Share on other sites More sharing options...
Guest Posted March 22, 2017 Share Posted March 22, 2017 Hi @yelyah.nodrog The columns h_responsesecs and h_fixsecs refer to how many seconds an analyst has to resolve that call - so for your example, in Incident IN00003618, they had 32 hours to resolve the request. To report on how long it actually took to respond and resolve a request, you should report on the columns: h_responsetime and h_fixtime For more information on what our columns refer to, we have information on our wiki: https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table Kind Regards Bob Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 22, 2017 Author Share Posted March 22, 2017 But its a P1? they haven't been set up to allow 32 hours for the call? I have a feeling i'm being really dumb here.... Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 22, 2017 Author Share Posted March 22, 2017 Also i cannot figure out how to find these h_responsetime and h_fixtime I know they are in the https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table I have been referring to it all day, But when i try to run a report their is not a option for these? I have looked in a entity and in sql but canot find them :/ Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 22, 2017 Author Share Posted March 22, 2017 Dont worry! i finally figured it out! thankyou so much!!!!!!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now