Can anyone produce a report that shows the number of tickets worked on outside of the regular business day 9-5pm that can show consilated figures monlty, yearly, and then allow the user to drill down to the ticket level showing the IT Support person and various ticket values that make up the data

AFAIK that's not possible, Spiceworks doesn't collect when you worked on a ticket just how much.

Ah, you're not looking for hours worked, just when they were closed. But doesn't your report already do that? Except back to first point, I could work on a ticket for three hours during the day but not close it until 10pm, it shows 1 in the 10pm column.

This is another person report that i just modified the range and time. What i am looking for is who is doing the most work after hours by moth or year

Here is the code

--comment the next line and uncomment the following one to have the chart showing closed tickets
--instead of new ones
/*select time_range,New_Tickets,Closed_Tickets*/
select time_range,Closed_Tickets,New_Tickets
from
(select numar||':00-'||numar||':59' as time_range,
(select count(created_at) from tickets
where date(created_at)>=date('now','-90 days')
and abs(ltrim(strftime('%H',created_at),0))>=numar
and abs(ltrim(strftime('%H',created_at),0))<numar+1) as New_Tickets,
(select count(closed_at) from tickets
where date(closed_at)>=date('now','-90 days')
and abs(ltrim(strftime('%H',closed_at),0))>=numar
and abs(ltrim(strftime('%H',closed_at),0))<numar+1) as Closed_Tickets
from