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 Windows 7 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:22:43 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 10:55:07 AM(UTC)
Lansweeper Thunderbird 68 Vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: Today at 8:41:29 AM(UTC)
Lansweeper Drive Encryption statuses
by  JacobH  
Go to last post Go to first unread
Last post: Yesterday 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: Yesterday at 5:24:13 PM(UTC)
Lansweeper Number of scanned IPs
by  wayneRex  
Go to last post Go to first unread
Last post: Yesterday at 10:21:01 AM(UTC)
Lansweeper Ticket Summary by Agent?
by  susan.starr   Go to last post Go to first unread
Last post: 9/17/2019 4:41:26 PM(UTC)
Report Center Virtual machines and their host
by  klaus  
Go to last post Go to first unread
Last post: 9/17/2019 8:44:57 AM(UTC)