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: 131  
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 Cloud relay data stored time
by  Inaki Gomez   Go to last post Go to first unread
Last post: Today at 10:57:12 AM(UTC)
Lansweeper Scan UPS
by  FrankSc  
Go to last post Go to first unread
Last post: Today at 10:54:23 AM(UTC)
Lansweeper I Need a List of Hostname
by  Nicolas Burd   Go to last post Go to first unread
Last post: Yesterday at 7:31:34 PM(UTC)
Lansweeper User View Customization
by  DarkOne77  
Go to last post Go to first unread
Last post: Yesterday at 5:26:25 PM(UTC)
Lansweeper Acknowlege from Alerts
by  Brandon   Go to last post Go to first unread
Last post: Yesterday at 4:44:06 PM(UTC)
Lansweeper Helpdesk Custom field for working hours
by  Robert Tecklenburg  
Go to last post Go to first unread
Last post: Yesterday at 9:48:28 AM(UTC)
Lansweeper LsAgent.ini
by  IT-EPUDF   Go to last post Go to first unread
Last post: 4/21/2021 11:26:00 PM(UTC)
Lansweeper Lansweeper cisco LWAPP's
by  Scott G  
Go to last post Go to first unread
Last post: 4/21/2021 7:43:18 PM(UTC)