Notification

Icon
Error

Ticket Report Overview - Need Help to build a report

Posted: Wednesday, June 15, 2016 10:15:47 AM(UTC)
RhandyCH

RhandyCH

Member Original PosterPosts: 2
0
Like
This issue has been solved! Click here to view the solution
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
Nick.VDB
#1Nick.VDB Member Lansweeper Developer Administration Posts: 251  
posted: 7/11/2016 10:06:57 AM(UTC)
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


Code:
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
RhandyCH
#2RhandyCH Member Original PosterPosts: 2  
posted: 7/11/2016 10:50:32 AM(UTC)
Dancing Thank u very much. U were a big help for my and my Company.
Greet form CH
nmckinney
#3nmckinney Member Posts: 1  
posted: 8/15/2016 4:51:51 PM(UTC)
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?
Adam P.
#4Adam P. Member Posts: 2  
posted: 8/1/2019 9:33:43 PM(UTC)
Originally Posted by: nmckinney Go to Quoted Post
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
#5briangmiller Member Posts: 1  
posted: 8/20/2019 1:49:35 PM(UTC)
Originally Posted by: Adam P. Go to Quoted Post
Originally Posted by: nmckinney Go to Quoted Post
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.

Brick wall

Active Discussions

Lansweeper Drive Encryption statuses
by  JacobH   Go to last post Go to first unread
Last post: Today at 5:41:10 PM(UTC)
Report Center Local admin group report based on domain role
by  JacobH  
Go to last post Go to first unread
Last post: Today at 5:24:13 PM(UTC)
Lansweeper Number of scanned IPs
by  wayneRex   Go to last post Go to first unread
Last post: Today at 10:21:01 AM(UTC)
Lansweeper Ticket Summary by Agent?
by  susan.starr  
Go to last post Go to first unread
Last post: Yesterday at 4:41:26 PM(UTC)
Report Center Virtual machines and their host
by  klaus   Go to last post Go to first unread
Last post: Yesterday at 8:44:57 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 9/16/2019 1:38:33 PM(UTC)
Lansweeper Query on 'Assets: Installed software by computer' Report
by  RC62N   Go to last post Go to first unread
Last post: 9/12/2019 5:12:40 PM(UTC)
Lansweeper Adding Comments
by  AZHockeyNut  
Go to last post Go to first unread
Last post: 9/10/2019 7:39:40 PM(UTC)