Query Report History of tickets that have had 'Critical' Status
Trying to create query reporting tickets that have had a critical status in the past [currently outstanding and closed]. I've search several tables [ci, cihistory, audit, audithistory, workorder, etc ] and cannot find a table that can be used to list all status changes in a given ticket. Please advice.
Thank You in advance for your assistance.
Thank You in advance for your assistance.