I have not been able to find a suitable report on the forums.
I found this, but it does not identify as either breached or not.
Select Top 1000000 htblticket.ticketid As ID,
htblticket.subject As Subject,
htblticket.date As [Creation Date],
htblusers.name As [Created By],
htblticketstates.statename As State,
htblusers1.name As Agent,
htblticket.slainitial As [Initial Response Date\Time limit],
htblticket.slaresolved As [Resolve time Date\Time limit]
From htblticket
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Order By ID
Does anyone have any ideas please, I would just need 5 tickets breached, their number and how long the breach was for.
Thanks in advance
Tim
