Hi, Can anyone help with this please?
I have got this far however I cannot convert the agentid to the agent display name.
If I default link the htblagents table then the report will only display tickets where the agent and ticket user match, i.e. where we raise an internal ticket for ourselves to work on.
I have tried linking the htblagents various ways to htblticket and htblusers but to no avail.
I could put the report to Excel and vlookup the agent ID but if the reporting can convert the userid to display name I don't understand why I cannot do the same with the agent id.
Many thanks,
Kane.
Select Top 1000000 htblticket.date As [Date Opened],
htblticket.slaresolved As [Date Closed / Resolved],
htbltickettypes.typename,
htblticketstates.statename,
htblticket.subject,
htblticket.assetid,
htblticket.ticketid,
htblusers.name,
htblticket.agentid
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Order By htblticketstates.statename,
htbltickettypes.typename,
[Date Opened]