Jump to content

Widget - Top Request Resolver (Day/Week/Month)


Recommended Posts

Hi all,

I'd like to create a widget displaying the 'Top Request Resolver' of the day (and week, month, etc.)

How would I go about doing this so it shows the number of requests resolved as well as the name of the analyst?

Thanks in advance

Link to comment
Share on other sites

@dwalby here is how I would do it:

Top 10 resolvers:




SELECT h_resolvedby_username as Resolver, count(h_pk_reference) as Requests FROM h_itsm_requests where date(h_dateresolved) = curdate() group by h_resolvedby_username order by 2 desc limit 10;

This gives you the freedom to choose what to display as well as how many. change "10" by the number you want.


  • Thanks 1
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...