Recently I’ve had to write some custom queries to get data out of the Spiceworks database. I’ve found that the easiest way to do it is as follows:
- Open SQLite Studio (download it here)
- Grab a copy of the Spiceworks database, spiceworks_prod.db. It usually lives in C:Program Files (x86)Spiceworksdb on the machine running Spiceworks. The good thing is that this can be done without stopping the Spiceworks service.
- Add the database in SQLite, leaving all other options at their defaults, then click OK
- Right-click on the database, and click Connect
You’ll then be able to view the tables and browse their data. If I’m scripting something, I always compose and test the SQL queries here first before moving them across into my scripts.