Notification

Icon
Error

Export Ticket List

Posted: Wednesday, November 4, 2020 10:34:30 PM(UTC)
Chris H

Chris H

Member Original PosterPosts: 19
0
Like
In the Help Desk, I can add a new tab and create filters and columns to display the list of tickets I am interested in. Is there anyway to then export that list to an Excel sheet?

FrankSc
#1FrankSc Member Administration Posts: 127  
posted: 11/12/2020 7:51:05 PM(UTC)
Hello,

The best way to do this, would be to create a report that holds the same columns. From there you can then export that easily to Excel.
Chris H
#2Chris H Member Original PosterPosts: 19  
posted: 11/12/2020 8:00:45 PM(UTC)
Originally Posted by: FrankSc Go to Quoted Post
Hello,

The best way to do this, would be to create a report that holds the same columns. From there you can then export that easily to Excel.


Easier said than done. I am not a SQL programmer. When I opened a support case about getting a report showing help desk tickets including root cause I was told to take a SQL course.

When I saw how easy it was to filter and display exactly what I wanted right in the Help Desk itself, I was hoping for a way to export it right from there.

If you already have the tools to do the filtering built right in the Lansweeper application, why does the reporting have to be so convoluted?
Yassine Dakir
#3Yassine Dakir Member Posts: 1  
posted: 2/24/2021 12:29:07 PM(UTC)
Hi,

You can go to Reports > Create new report > then you can use this sql code :

Select Top 1000000 htblticket.ticketid,
htblticket.date,
users1.name As agent,
htblticket.subject,
users2.name As Utilisateur,
htblticketstates.statename As Statut,
htblnotes.date As date_Note,
users3.name As user_Note,
htblnotes.note
From htblticket,
htblusers As users1,
htblusers As users2,
htblusers As users3,
htblagents,
htblticketstates,
htblnotes
Where users1.userid = htblagents.userid And htblticket.agentid =
htblagents.agentid And htblticket.fromuserid = users2.userid And
htblticket.ticketstateid = htblticketstates.ticketstateid And
htblticket.ticketid = htblnotes.ticketid And users3.userid = htblnotes.userid



then you can save and run (Don't forget to assign a name for this sql code at the top of the page)
Good Luck
Chris H
#4Chris H Member Original PosterPosts: 19  
posted: 3/8/2021 6:58:56 PM(UTC)
Originally Posted by: Yassine Dakir Go to Quoted Post
Hi,

You can go to Reports > Create new report > then you can use this sql code :



Unfortunately this creates a report with a separate record for every note added to every ticket.

I feel like all the functionality is already built into the ticket filter in the Help Desk. I can filter my ticket view by date range, type, status, etc... I can add or remove the columns that I want. I just wish there was a way to export that to Excel. I'm not a programmer, but it seems to me like the hard work is already done. The filters are already there. If it can viewed on the screen, why can't it be exported?

Active Discussions

Lansweeper Acknowlege from Alerts
by  Hilbers   Go to last post Go to first unread
Last post: Today at 7:55:38 AM(UTC)
Lansweeper LsAgent for Windows command line options?
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 4:49:17 PM(UTC)
Lansweeper EmailLog.txt file become big in size
by  Ary Ahmed   Go to last post Go to first unread
Last post: 4/18/2021 10:56:58 AM(UTC)
Lansweeper LsAgent.ini
by  Orion Poplawski  
Go to last post Go to first unread
Last post: 4/17/2021 4:49:12 PM(UTC)
Lansweeper LSagent force a scan
by  Orion Poplawski   Go to last post Go to first unread
Last post: 4/17/2021 4:46:49 PM(UTC)
Lansweeper MS Edge Chromium LanSweeper Extension development
by  steveb  
Go to last post Go to first unread
Last post: 4/16/2021 10:59:56 PM(UTC)
Lansweeper Office 365 v2 Scanning Error
by  DJX   Go to last post Go to first unread
Last post: 4/16/2021 7:37:57 PM(UTC)
Lansweeper Database size growing too large
by  JTempleton  
Go to last post Go to first unread
Last post: 4/16/2021 5:19:22 PM(UTC)