Spiceworks report to tickets closed by user for the day

Spiceworks report to tickets closed by user for the day

Open up SQLLitePro in my case I used SQLlite2009 Pro and then went to
C:\Program Files (x86)\Spiceworks\db\spiceworks_prod  database

and then went to the users table and did a where clause to get my user id

WHERE email = 'username@domain.edu'

I then created my SQLlite query to show a report of total tickets processed for the day

SELECT tickets.id, tickets.summary, tickets.created_at AS 'Opened Date', tickets.due_at, tickets.closed_at, tickets.category, tickets.c_department AS 'Department' FROM ticketsWHERE tickets.closed_at>=date('now','-1 day') AND tickets.assigned_to = '7476'ORDER BY tickets.id;