When you create custom reports with the Reports Builder, tickets that have been Ticket archiving will not show up if you query only for resolved tickets.
Archived tickets have a tickets.status value of ‘archived’.
To ensure you match resolved OR archived tickets, you should check for:
WHERE tickets.status IN ('resolved', 'archived')
There is also a
tickets.date_archived field which indicates when the ticket was last archived.
Note that the built-in reports for resolved tickets already include archived tickets.