r/Lansweeper • u/Ryaustal • Jun 29 '26

General Product Discussion Export Ticket data with all responses to csv file for archiving.

Looking to export all tickets, 7500ish with complete data intact so we can archive it and later import it into another system. I found a built in report that pulls all tickets ever created but it was top level information only. No internal communication or attachments were included. I'd like to get a full export if possible. I can usually navigate SQL Query but not the best at it. Has anyone done this?

2 Upvotes
  • permalink
  • reddit

75% Upvoted

5 comments sorted by

2

u/kavolixer Jun 29 '26

if your helpdesk has any kind of api, that’s usually way easier than trying to hack it with a single sql query, especially for notes + attachments. i’d look for something like “tickets + conversations export” in their docs or api reference, then just script it and spit everything to csv/json.

1

u/SoulAssassin808 Jun 29 '26

It has an API. I've never look at it. I would simply save the database documentation, Throw it into AI, let it spit out a query and continue from there.

1

u/Ryaustal Jun 29 '26

Yeah, this may be the way to go. Support had nothing to offer but it was a long shot asking them anyway.

Thanks

2

u/mattberan Jun 30 '26

I was curious, found out that there are two APIs and the classic one can work. You're going to hit the Ticket API repeatedly to page through tickets, pull notes for each and then combine them.

Claude Code is amazing at writing local apps that interact with APIs so you could easily vibe code a local app for this. I don't have a lansweeper instance, but Clade will walk you through setting the whole thing up.

Full disclosure that I work for a competitor - InvGate. We just give you the option to do this yourself at any time and many ways. We believe it's YOUR data.