K1000 Closed Ticket Metrics Script
I've just inherited Kace from my new employer. I do not have a SQL background but I've been able to muddle my was on some basic reporting. One report I need is a 30 day (or whatever timeframe) metric report of assigned tech users closed ticket count. Just a count per each user, not a listing of all closed tickets. I've been searching a lot of the scripts but I'm not finding one that I can modify to work. Anybody have one already created? Thanks for the assist.
Closed Ticket for Techs
Assigned Tech's name #1 <closed ticket count>
Assigned Tech's name #2 <closed ticket count>
Assigned tech's name #3 <closed ticket count>