Ticket Report Overview

[RhandyCH]

Hello, i hope someone can help me.
We are switching from our current helpdesk tool OTRS to the new Lansweeper Helpdesk. I’m having a problem to create reports from our tickets like we do in OTRS.
The reports should show us following informations:
- Ticket ID
- Ticket subbject
- Ticket date
- Name of User who send (made) the ticket
- Ticket state like "in Progress, closed,..)
- Agent Name who got the ticket
- Reactiontime to sla

I would be really happy to get an answer and a code to build a Report.

Thank you very much.

Best regards

[nmckinney]

This was helpful. What I need is the ability to see the comment history. Could you point me to that table and how to add it into this report?

[aparis99]

nmckinney wrote:
This was helpful. What I need is the ability to see the comment history. Could you point me to that table and how to add it into this report?

Did you ever find out how to pull ticket comments?

[briangmiller]

Adam P. wrote:

nmckinney wrote:
This was helpful. What I need is the ability to see the comment history. Could you point me to that table and how to add it into this report?

Did you ever find out how to pull ticket comments?

I am also trying to figure out how to add comments or, ideally, the last user or agent note in the ticket on the report. I have an IT Tickets Aging Report that has Ticket #, Subject, Creation Date, Status, Type, Source, User, Agent, Days Since Creation and the last column I want to be "Last Comment (or note - in ticket)"...something to that effect.

[RhandyCH]

Thank u very much. U were a big help for my and my Company.
Greet form CH

[Nick_VDB · Accepted solution]

Below is a report that will give back a ticket overview. We added the fields you requested except for the 'Reactiontime to sla'. There is not existing field that will give back, this would require a more advanced SQL report to calculate manually. You can follow the instructions found here to add the report to Lansweeper

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