Reporting on Ticket Attachments in Lansweeper

[apiknowbler]

Summary

To find out which helpdesk tickets in Lansweeper have which attached files, you can use a SQL report. Attachments in Lansweeper are stored as files on your web server — not inside the database — but their metadata (names, associations, and identifiers) are stored in database tables such as htblattachments, htblnotes, and htblticket.

Steps to identify which attachments belong to which tickets

1. Create the SQL report

Open your Lansweeper web console and go to Reports > Create New Report.
Paste in the following query:

Select Top 1000000
  htblticket.ticketid,
  htblnotes.ticketid As [Ticket ID],
  htblattachements.filename As [Attachment],
  htblattachements.deleted,
  htblfiles.uid As [Compressed File]
From htblattachements
Inner Join htblnotes On htblnotes.noteid = htblattachements.noteid
Inner Join htblticket On htblticket.ticketid = htblnotes.ticketid
Inner Join htblfiles On htblfiles.fileid = htblattachements.fileid

This report lists:

• The ticket ID
• The attachment filename
• A flag showing if the file was deleted
• The unique ID (UID) of the compressed file

2. Save and run the report

Save your report, then click Run Report Now to generate results.
You’ll see which attachments correspond to which helpdesk tickets.

3. Locate the actual files

The physical files are stored (by default) in this folder on your Lansweeper server:

C:\Program Files (x86)\Lansweeper\Website\helpdesk\files

If your web and scanning services are on separate machines, ensure both have access to this folder.
For configuration guidance, see the article below.

---

Related Knowledge Base Articles

Where Lansweeper data, reports, and settings are stored
Explains database and file storage structure.

Resolve ticket attachment issues
Describes how attachments are stored and accessed between web and scanning servers.

Accessing the Lansweeper database documentation
Helps you understand which database tables store helpdesk data.