chriscorcoran Posted May 8, 2017 Share Posted May 8, 2017 Hi I'm trying to extract all calls of a particular services that have breached the resolution timer, anybody know what I SQL i need to add to get the correct data? Thanks Chris Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2017 Share Posted May 8, 2017 Hi Chris Well one way would be to create a view on the request list. In the screenshot I have attached, I have specified a condition 'within resolve time' is false and I have specified the name of the service. This view can be downloaded as a csv file showing the requests that have breached the resolution SLA. Is this similar to what you were looking for? regards Pamela Link to comment Share on other sites More sharing options...
chriscorcoran Posted May 8, 2017 Author Share Posted May 8, 2017 I also need the ability to show calls that have been reopened is that possible? Outcome: Call Reopened Link to comment Share on other sites More sharing options...
chriscorcoran Posted May 8, 2017 Author Share Posted May 8, 2017 Thanks Pamela, I will give that view a try, thanks Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2017 Share Posted May 8, 2017 @chriscorcoran In order to include re-opened calls, you can add the 'Reopened' is greater than 1 condition to the view. Hope that helps Thanks Pamela Link to comment Share on other sites More sharing options...
chriscorcoran Posted May 8, 2017 Author Share Posted May 8, 2017 Thanks Pamela, that's great. Chris 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