→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lurchi
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
Our database documentation explains what each Lansweeper table stores and can be searched using your web browser's search function: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-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.com/knowledgebase/where-lansweeper-data-reports-and-settings-are-stored/

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
Our database documentation explains what each Lansweeper table stores and can be searched using your web browser's search function: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-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.com/knowledgebase/where-lansweeper-data-reports-and-settings-are-stored/