"Install PSSQLite module from the Powershell Gallery to allow the script to read the Spiceworks backup SQLite database file." ps1 part on the end is important.Ĭlick here to skip to the end of the script The Script Then copy the code below and save with the file name Convert-SpiceworksToLansweeper.ps1 in the working folder. Open notepad or another plain text editor.
#LANSWEEPER VS SPICEWORKS HOW TO#
It may also help to read the first article of how to do this manually which shows you all the same steps but with Excel instead of Powershell.
Powershell is generally easy to read and there are a lot of comments in the script that explain everything it is doing. If this makes you nervous, I encourage you do read through the script and do a web search for any command that sounds strange to you. Note: To run this, you’ll need to run PowerShell as administrator, enable scripts, and allow the script to download a module from the PowerShell gallery. Make sure there are no other zip files in the working folder. For me that address was \\spiceworks\c$\Program Files (x86)\Spiceworks\Backup. In my examples this will be C:\Users\Admin\Documents\Lansweeper.Ĭopy the backup zip file from the server to the working folder using either Remote Desktop copy paste or a UNC path in file explorer which seems to be a bit faster. On a computer running Powershell 5.1, Windows 10 or Server 2016, create a new folder called Lansweeper which I’ll call our working folder. If it looks odd or the file size is 0 or growing, Spiceworks may not be finished backing up yet. By default, it’s in C:/Program Files (x86)/Spiceworks/backup. Locate the backup zip file on the server. Note that once you do this export, any new tickets or updates that come into Spiceworks will not be imported into LanSweeper. It may take several minutes for the backup to complete. Click Backup Now and note the Backup Location folder. Exporting from Spiceworksįirst open Spiceworks and go to Settings > Global Settings > Backup Configuration.
#LANSWEEPER VS SPICEWORKS INSTALL#
It may be possible to run the Help Desk Export from the cloud version, install the on premises version of Spiceworks, import the JSON file, then follow this tutorial from there. Note: In this tutorial we are dealing with the on premises version of Spiceworks not the cloud version. Now I have a Powershell script that can do much of that work for you. I previously wrote how an article on how to Migrate from Spiceworks Tickets to Lansweeper using ODBC, Excel, and manual labor.