RangerMSP Business Automation for successful ITs

 
July 24th, 2020, 01:20 PM
nattivillin
 
Posts: 1,146
I would like to know how long a ticket has been in the status it is in. For example, we have a status (pending Billing). This is where tickets go to be reviewed before close.

I would like to know how long a ticket has been in pending billing. I would also like to know how long a ticket has been in work, or any status it is in.

A bonus if ranger can tell me how long a ticket was in any and all previous statuses.

Where can i go to see the time a ticket was in a status? Currently I only see a timer for total open time.
 
July 27th, 2020, 06:11 AM
Support Team
 
Posts: 7,510
Thank you for posting this.

On changing the Ticket Status, the system adds an audit record that can be viewed under the Ticket History tab. The audit note contains information when the status was changed, who changed it and what was the previous status.

Such audit information is displayed to you as a text field, as well as saved like it in the database, and therefore calculations on such textual data are not supported at this time. For what it is worth, you may use our API to fetch the data and parse the notes to gather that info.
Hope this helps.
 
July 28th, 2020, 09:34 AM
nattivillin
 
Posts: 1,146
We could write some custom code using the API to calculate the status length(s)?
 
July 28th, 2020, 11:14 AM
Support Team
 
Posts: 7,510
Yep. You'll need to query the Ticket History notes from the database, parse them, and translate it to the information you need.

Hope*this helps.
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search



All times are GMT -6. The time now is 05:05 AM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.