Joyce Posted November 9, 2018 Share Posted November 9, 2018 Hi, Does Request.Total.Onhold.Time field on table h_itsm_requests contain the total seconds that a request has been placed on Hold? If so, why are some of our request which has been placed on hold, have no value on this field? If it isn't is there another field which record the total duration a ticket has been on hold so far? All the above ticket have been resolved, so i was expecting to see values on total onhold time. Thanks. Regards, Joyce Link to comment Share on other sites More sharing options...
Victor Posted November 9, 2018 Share Posted November 9, 2018 25 minutes ago, Joyce said: Does Request.Total.Onhold.Time field on table h_itsm_requests contain the total seconds that a request has been placed on Hold? Yes. 25 minutes ago, Joyce said: why are some of our request which has been placed on hold, have no value on this field? Because this field gets populated when the request is taken off hold. When the request is taken off hold Hornbill will calculate for how long the request was on hold and update this field. 25 minutes ago, Joyce said: All the above ticket have been resolved Were they resolved while on hold? Link to comment Share on other sites More sharing options...
Joyce Posted November 12, 2018 Author Share Posted November 12, 2018 Hi Victor, Yes I think so, they get resolved automatically by completing the last task. This could be done while onhold. So will this be the reason why the field is not populated? Regards, Joyce Link to comment Share on other sites More sharing options...
Victor Posted November 12, 2018 Share Posted November 12, 2018 22 minutes ago, Joyce said: they get resolved automatically by completing the last task. This could be done while onhold. So will this be the reason why the field is not populated? Ermm... could be... if you say they get resolved automatically, I assume is the business process that does it... can you PM me a copy of the process definition file so I can have a look, please? Link to comment Share on other sites More sharing options...
Joyce Posted November 12, 2018 Author Share Posted November 12, 2018 I have send you the BPM Definition file Link to comment Share on other sites More sharing options...
Joyce Posted November 12, 2018 Author Share Posted November 12, 2018 This is just one of the process. We have a few process, which get resolved autocratically by tasks. Link to comment Share on other sites More sharing options...
Victor Posted November 13, 2018 Share Posted November 13, 2018 @Joyce - I have reviewed the process and I think I know why the information is missing. As I mentioned above, it appears the business process resolved those requests while they were on hold. Therefore the on hold time was not calculated. I suggest the following: in your business process, before resolving the request, add a node to take the request off hold. This node will ensure the on hold time is calculated if the request was on hold. Link to comment Share on other sites More sharing options...
Joyce Posted November 13, 2018 Author Share Posted November 13, 2018 @Victor Thank you for this. Our Hornbill Support analyst will not like me, when I have to ask for the changes on the BPMs. Is there any other way of getting the total Onhold ( maybe a back end code on resolution node to take ticket offhold during resolution)? we have a lot of BPM which closed automatically. Regards, Joyce Link to comment Share on other sites More sharing options...
Joyce Posted November 13, 2018 Author Share Posted November 13, 2018 @Paul Alexander this is my thread. Feel free to comment Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted November 13, 2018 Share Posted November 13, 2018 @Victor Dayum right he won't like it! We have around 200 BPM's which MAY autocomplete after the last Activity is completed, this really isn't going to happen! As @Joyce suggested, could there be a change so that the Request.Total.Onhold.Time field is updated on ticket resolution? Or, one to prevent activities being completed if the parent ticket is on hold? Oh I hope the answer is 'yes' to one of these questions Link to comment Share on other sites More sharing options...
Victor Posted November 13, 2018 Share Posted November 13, 2018 @Paul Alexander @Joyce 1 hour ago, Paul Alexander said: could there be a change so that the Request.Total.Onhold.Time field is updated on ticket resolution? Or, one to prevent activities being completed if the parent ticket is on hold? I personally don't see why any of these would not be possible... The real question is: will it be done? and the more important one: when? ... but this is something @Steven Boardman and/or @James Ainsworth can advise on... and possibly contradict me saying is not actually possible... Regarding the BP owner and changing all the BPs... when I am facing such scenarios, like resistance, I always use this: Link to comment Share on other sites More sharing options...
James Ainsworth Posted November 22, 2018 Share Posted November 22, 2018 @Paul Alexander Do you know if request Sub-statuses are used on any of these requests? Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted November 27, 2018 Share Posted November 27, 2018 HI @James Ainsworth Sorry...I missed this post! Sub Statuses are not used in the BPM's (as far as I can remember anyway!!) thanks Link to comment Share on other sites More sharing options...
Joyce Posted November 27, 2018 Author Share Posted November 27, 2018 Hi @James Ainsworth , I would like to officially request for a change, to calculate 'Request.Total.Onhold.Time' for a ticket even if it was closed while still onhold. As we have more than 200 BPM which close tickets automatically, we should rather not spend time changing all these BPMs. Please advise if this is possible, and the time scale for this change to be implemented. Thanks. Kind Regards, Joyce Link to comment Share on other sites More sharing options...
James Ainsworth Posted November 27, 2018 Share Posted November 27, 2018 Hi @Joyce The change proposal for this has already been submitted. I just needed a bit more info on sub-statuses. There may be some complication for customers that use request sub-statuses in conjunction with a setting like this. The change is still being planned and not yet scheduled. I can't provide a timescale as of yet as it needs to go through our planning procedures. Once ready, the change enters a "90 Day" delivery window. This does not always equate to a change taking this long. If the requirement is straight forward to implement and has no impacts it will often move a little faster. I'll update the post once it has progressed. Regards, James Link to comment Share on other sites More sharing options...
James Ainsworth Posted January 9, 2019 Share Posted January 9, 2019 @Joyce and @Paul Alexander We have completed some development work which will automatically take a request off hold at the point that a request is resolved. Once this update is applied there will not be any action or setting required for this to work. This looks like it will be ready to be available in one of the next Service Manager updates. Keep an eye open on the release notes. I'll provide a final confirmation once it is available. Regards, James Link to comment Share on other sites More sharing options...
Joyce Posted January 10, 2019 Author Share Posted January 10, 2019 Thanks for the update @James Ainsworth Looking forward to the change . Regards, Joyce Link to comment Share on other sites More sharing options...
James Ainsworth Posted January 17, 2019 Share Posted January 17, 2019 Hi @Joyce This is now available as of Service Manager build 1408. There is nothing to set up or configure. This will just start working. Regards, James Link to comment Share on other sites More sharing options...
Joyce Posted January 23, 2019 Author Share Posted January 23, 2019 Great thanks @James Ainsworth 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