Adrian Simpkins Posted November 23, 2020 Share Posted November 23, 2020 Hi All, We have today created a new request list view to output some data for a report where we want to show the Response / Resolve SLA set when the call raised, and then show the date Resolved / date Closed data. This is fine, however there are some columns I am struggling to understand the values shown on the report: Resolve Time / Response Time - this appears to be showing just as a Numeric value. As an example we have a request Raised on the 19th October with a respond by date of the 5th November, with a resolution date of the 16th November. The request was responded to on the 1st November, and resolved on the 12th November. The Resolve / Response Time columns show a value of 61207 for the Response Time, and 273936 for the Resolve Time. Within Response / Resolve Timer - this column shows a 0 and 1 as values. Using the same request this shows the Within Response Time and Within Resolve timer as 1 - I presume a 0 indicates failed to respond/resolve within time, and a 1 indicates we did respond within the defined times? I have included a screen shot of one of the data records below: Many thanks Link to comment Share on other sites More sharing options...
Deen Posted November 23, 2020 Share Posted November 23, 2020 @Adrian Simpkins I have double checked against our own system and these timings are in seconds. For example a request has its response marked 5 minutes after it is raised, Response time is then listed as 540 seconds. 1 Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 24, 2020 Author Share Posted November 24, 2020 Hi Deen, Thank you I did suspect it was in seconds. I presume there is no way to output this in anything other than seconds? Did you also try the 0/1 output on the within Response Time / within Resolve Time columns? Just wanted to confirm that a 0 means failed, and a 1 means success? Many thanks ! Link to comment Share on other sites More sharing options...
Guest Mary Posted November 24, 2020 Share Posted November 24, 2020 Hi @Adrian Simpkins The within response and within fix columns store the value 1 if the target was met and 0 if it was breached. Further details about the columns available in the h_ itsm_requests table are found in Home> Applications> Service Manager> Entity VIewer . Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 24, 2020 Author Share Posted November 24, 2020 Hi Mary, thank you that is exactly what i was after! Many thanks 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