Notification

Icon
Error

Helpdesk Report - Show content - Show the content of a ticket in reports

Posted: Friday, May 10, 2019 8:46:59 AM(UTC)
lurchi

lurchi

Member Original PosterPosts: 2
0
Like
This issue has been solved! Click here to view the solution
Is it possible to show the content (text only) of a ticket in a report?
What table is needed therefore?

Attachments like pictures are not needed, presumably it's not possible either.
Susan.A
#1Susan.A Member Administration Posts: 1,535  
posted: 5/29/2019 9:06:25 AM(UTC)
Our database documentation explains what each Lansweeper table stores and can be searched using your web browser's search function: https://www.lansweeper.c...-database-documentation/

Help desk ticket notes are stored in the htblnotes table. Keep in mind though that the entire HTML of the note is stored in the database, not just the text. The output would not be very readable. To attempt to strip HTML from the notes, you would have to start using advanced SQL scripts or functions, which neither we nor our report builder provides support for, unfortunately.

In regards to attachments: attachment names are stored in the database, but the actual attachments are stored as files on your web server and not in your database. This knowledge base article explains where Lansweeper files are stored: https://www.lansweeper.c...and-settings-are-stored/

Active Discussions

Lansweeper Report for SSAS and SSIS
by  The Boss   Go to last post Go to first unread
Last post: Yesterday at 6:53:21 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc   Go to last post Go to first unread
Last post: Yesterday at 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 8:40:47 AM(UTC)
Lansweeper User association report query
by  dan508   Go to last post Go to first unread
Last post: 6/24/2019 5:38:51 PM(UTC)
Lansweeper Dell SupportAssist CVE-2019-12280
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 9:15:20 AM(UTC)
Lansweeper Office 365 OneDrive Usage and Sync
by  brodiemac   Go to last post Go to first unread
Last post: 6/21/2019 3:51:36 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: 6/21/2019 9:52:22 AM(UTC)